Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Metering Office 97 products | Excel Discussion (Misc queries) |