hi,
how are you concatenating now?

regards
FSt1

"Lynn Bales" wrote:

I've been concatenate two columns together and using a defined range, but
when I do this I always wind up with either not enough rows, or to many rows.
I'd like to know how to find the last row of data and then use that in a
macro to only concatenate what I have, is this possible?