Unfortunately this does not adress my VBA question. I understand how to hard code concatenation into a worksheet.

What I need help with is conditionally concatenating varying range sizes in VBA. (Also I am using 2007 and Conc does not seem to be a valid function anymore)

I do appreciate the reply however.