Hi Frank,

Am Tue, 30 Jun 2015 21:26:19 -0400 schrieb Phrank:

I tried this below, and I figured it wouldn't work since myRng is
being passed as a range. I think the concept might be right, but how
would I get the value of each cell in myRng passed through to be
evaluated in j = 1 to 7?

have another look
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Concatenate"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional