I'm not entirely clear what you want, but the & operator combines
text strings. E.g.,

Dim Res As String
Res = Range("A1").Value & " " & Range("B1").Value & " " &
Range("C1").Value
MsgBox Res

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"c mcg"
wrote in message
...

Hi Guys great forum

im trying to create a macro that combines data from cells at
any point
in my spreadsheet.

for instance I want to combine 3 cells that have a name in i.e

A= MR
B= JOHN
C= SMITH

however i also to combine there addresses e.g x = 74 y = the z=
green.

is there any type of vba that could perform this for me.

any help will be greatly appreciated.


--
c mcg
------------------------------------------------------------------------
c mcg's Profile:
http://www.excelforum.com/member.php...o&userid=33560
View this thread:
http://www.excelforum.com/showthread...hreadid=533465