| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenate
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. ------------------------------------------------ Message posted from http://www.ExcelTip.com/ -- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum -- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/ ------------------------------------------------ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
concatenate
Your formula looks fine. Which error do you get ?
-- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please "rabbit" skrev i melding ... 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. ------------------------------------------------ Message posted from http://www.ExcelTip.com/ -- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum -- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/ ------------------------------------------------ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE | Excel Worksheet Functions | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| concatenate and then take off last # | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| concatenate | Excel Worksheet Functions | |||
Hybrid Mode
