If you are trying to find the last used row in a column, use something like
this

Dim rng As Range
Set rng = Range("a65536").End(xlUp)

which will set rng to the very last used cell in col A (assuming you don't
have data all the way down to the last row)


"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?