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