Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macro to join up strings
Hi,
It seems like you don't need VBA for that. You can just type =A1&" "&B1&" "&C1 in cell D1. If you need/want to do it in VBA, cells(1,4).FormulaR1C1 = "=RC[-3]&"" ""&RC[-2]&"" ""&RC[-1]" "stuart" wrote: Hi, This is a simple example of what I need help with. In Excel cell A1 contains the word "The", cell B1 contains the word "Blue" and cell C1 contains the word "Ocean". I need to write a VBA macro so that cell D1 contains "The Blue Ocean". But I don't know the syntax for doing this. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to join sheets from different workbooks | New Users to Excel | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
VBA macro to join up strings | Excel Programming | |||
join strings in VB with Pivot methods | Excel Programming | |||
Excel Macro Strings | Excel Programming |