Expected End of Statement "001"

[CRMTHB]

Hi,

I am trying to attach the following into an existing macro:

ActiveCell.FormulaR1C1 = "=VLOOKUP((LEFT(A3,4)&"001"),'GP IMPORT'!$C:$T,18,0)"

I keep getting an error highlighting the 001 section of this. "Compile Error. Expected: end of Statement"

Where have I gone wrong?

Thanks

 

[FormR]

Hi, an easy way to get the correct syntax in VBA is to use the macro recorder whilst manually entering the formula in the worksheet.

You could try:

ActiveCell.Formula = "=VLOOKUP((LEFT(A3,4)&""001""),'GP IMPORT'!$C:$T,18,0)"