Dim LastRow As Range
Set LastRow = Cells(Rows.Count, "A").End(xlUp)
LastRow.Offset(1).Select

Hope this works for you

"cbh35711" wrote:


Using macros...
I'm converting one file to another by copying and pasting data. I want
to paste the second set, and every subsequent set, below the data I
pasted before. The problem is Im not sure how to select the first
empty row in column A. I know I could write a loop, but there's got to
be a better way. I've thought of filtering it to show only nothing and
that would allow me to see the first empty row...but Im not sure what
command to use after that.

Thanks for any help you can offer,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=527595