Stuart,
You can do this with a formula rather than VBA. E.g., in cell D1,
=A1&" "&B1&" "&C1
If you do want VBA, use
Range("D1").Value = Range("A1").Value & " " & Range("B1").Value &
" " & Range("C1")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"stuart" wrote in message
...
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.