How do I jump to the last populated cell in a column?
Printable View
How do I jump to the last populated cell in a column?
Assuming you want to jump to the last populated cell in a column using VBA
will do; where 1 is the column index (1=A, 2=B etc)Code:Worksheets("Name of sheet").Cells(Rows.Count, 1).End(xlUp).Select
Thanks for your reply. However, I need to move the cursor to that cell for data entry. I should have stated that.
I've discovered how to do just what I want (& more).
To move to the last cell in a contiguous block of blank or non-blank cells, simply double-click on the current cell's border. The border chosen will determine the direction of the move. If you're in the middle of a large block of data and you want to move to the top cell within that block of data, simply double-click the top border of the current cell. You'll know you're in the right place to double-click because the cursor will change to a four-headed arrow. If you want to move to the last cell to the right within that same block of data, double-click the current cell's right border. The same is true when moving to the left or down.
In my situation, selecting the column & then double-clicking the cell's bottom border will take me to the desired cell.