How do I enter a Formula into excel using VBA

[wimuggs]

I am trying to have Visual Basic enter a formula into a spreadsheet so I can copy it down a column.

Here is the line in Visual basic:
ActiveCell.FormulaR2C2 = "=CONCATENATE(R1C3," - ",R2C4)"

Whenever I try to run it I get a Run time error 13: Type Mismatch.

Any help would be greatly appreciated.

Thank you

 

[pbrodsky]

try
activecell.formulaR1C1= "=CONCATENATE(R1C3,"" - "",R2C4)"

You need to double quote marks inside a quoted string.

 

[wimuggs]

Thank you. That resolved the issue.