Jump to Last Used Cell in a Column?

[jarhtmd]

How do I jump to the last populated cell in a column?

[Excel Fox]

Assuming you want to jump to the last populated cell in a column using VBA


Worksheets("Name of sheet").Cells(Rows.Count, 1).End(xlUp).Select will do; where 1 is the column index (1=A, 2=B etc)

[jarhtmd]

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.