Thread: Formula in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RC- RC- is offline
external usenet poster
 
Posts: 12
Default Formula in VBA

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-