Formula in VBA

  • Thread starter Thread starter RC-
  • Start date Start date
R

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-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With VLOOKUP VBA Script Line 1
Excel How to code in excel vba 2007 using absolute refernce for cells 1
Vlookup in vba - how to use absolute rows not relative 1
File Name changes with dates and Deleting Rows of Zeros 0
Range formula copy 4
Combine 2 columns in a dynamic range into one 7
Geometric progression in VBA 10
Excel Help to copy information from one row at a time to another sheet 1

Back
Top