Selecting first empty row in column
 

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

Thanks for any help you can offer,

Chri

--
cbh3571
-----------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...fo&userid=3027
View this thread: http://www.excelforum.com/showthread.php?threadid=52759

Selecting first empty row in column
 

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

Selecting first empty row in column
 

Perfect, thank you so much.

Chris


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