Find first empty row to append data

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/viewtop...c=1767&forum=2