Find first empty row to append data

[Guest]

How do you locate the first empty row after the end of a column of data so more data can be added. My appologies, I know this is on the board somewhere, just haven't been able to find it in the last hours. Thanks in advance.

 

[NateO]

Something like this perhaps (in vba):

Sub gtIt()
Selection.End(xlDown).Offset(1, 0).Select
End Sub

In non-vba, press your "End" key and hit your down arrow twice.


Cheers, Nate
This message was edited by NateO on 2002-03-12 14:34

 

[Steve Hartman]

Funny, I found it in less than 3 seconds.

http://www.mrexcel.com/board/viewtopic.php?topic=1767&forum=2