Formula in VBA

[RC-]

How can I get this formula to work in Excel using VBA?

ActiveCell.FormulaR1C1 = "=CONCATENATE(Employee_Data!$B3, ""
"",Employee_Data!$C3)"

I keep getting an application defined error.

Any help would be great
RC-

 

[Niek Otten]

Either use ActiveCell.Formula or change your formula to R1C1 references