concatenate

  • Thread starter Thread starter rabbit
  • Start date Start date
R

rabbit

I want to use CONCATENATE in VBA (Excel). I used Activecell.FormulaR1C1
= "=CONCATENATE(RC[-2],RC[-1])" , on this statement I get a error
message.



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------
 
Your formula looks fine. Which error do you get ?
--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

rabbit said:
I want to use CONCATENATE in VBA (Excel). I used Activecell.FormulaR1C1
= "=CONCATENATE(RC[-2],RC[-1])" , on this statement I get a error
message.



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at
Click to expand...
http://www.ExcelTip.com/
------------------------------------------------
Click to expand...
 
You must log in or register to reply here.

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

Autoamate Concatenate Function 3
Concatenate /w Chr(10) error 2
Mix of relative and absolute? 4
Excel formula in macro 3
macro to copy rows that contain a cell with a certain number 2
Help with Concatenating 4
Macro that deletes and pastes filterd rows and then some 2
Get Info From Another Sheet 6

Back
Top