Hi I am trying to include a macro that will copy formulas down until the last row of data but it keeps giving me a compile error:Expected end of statement.
The first is trying to copy a vlookup formula, the second line is trying to copy a simple row number
Thanks!
Sub CopyFormulas()
Range("G7:G" & LastRow).Formula = "=IFERROR(VLOOKUP(TEXT(G7,0),'N:\X:\Purchase_Part_Library\[BOM NAV Item List.xlsx]Sheet1'!$A$8:$I$1000000,5,FALSE),"N/A")"
Range("Q7:Q" & LastRow).Formula = "=ROW()-6"
End Sub
The first is trying to copy a vlookup formula, the second line is trying to copy a simple row number
Thanks!
Sub CopyFormulas()
Range("G7:G" & LastRow).Formula = "=IFERROR(VLOOKUP(TEXT(G7,0),'N:\X:\Purchase_Part_Library\[BOM NAV Item List.xlsx]Sheet1'!$A$8:$I$1000000,5,FALSE),"N/A")"
Range("Q7:Q" & LastRow).Formula = "=ROW()-6"
End Sub