Trouble with IF statement in VBA

[General Ledger]

Dear All,

I am having trouble in VBA for an Excel 2003 project. The following works fine:
Range("AccountNumber").FormulaR1C1 = "=VLOOKUP(Template,TemplateDetails,4,FALSE)"

The following gives me a run time error 1004 Application-definded or object-defined error:
Range("AccountNumber").FormulaR1C1 = "=IF(ISNA(VLOOKUP(Template,TemplateDetails,4,FALSE)),"", _
VLOOKUP(Template,TemplateDetails,4,FALSE))"

The formula works fine when used in a cell on a worksheet. When I put it into VBA, I get the error. I am guessing the double quotes in the formula are the root of the problem. Do I put quotes around the quotes?

Best regards,

GL

 

[Domski]

Do I put quotes around the quotes?

Yep

 

[SamTYler]

"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

 

[jbeaucaire]

TIP OF THE DAY: Whenever I create a formula that will be written into cells via VBA, I get the right VBA syntax quickly by just typing the formula out first in the first target cell while the macro recorder is running. That will give you the correct base code...easy to tweak from there.