It depends, if the column is filled all the way you can use ctrl + downarrow
otherwise you'll need to roll your own
Sub TestMe()
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Offset(1, 0).Select
End Sub
will select the first empty cell after the last netry in a column
Regards,
Peo Sjoblom
"Greg" wrote:
I use the 'find' key to locate the column I want to make entries in, however
the column is getting too long and I have to page down to get to the first
empty row. Is there a way to use 'find' or another method to take me
directly to the last row in the desired column? Thks, Greg
|