With xl2000 or later versions, you can use the VBA.Join function.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Data Options add-in: rows/dates/random stuff)
"jt"
wrote in message
...
is there a way to concatenate a range instead of having to
individually select each cell, thanks in advance