Shortcut to Jump to Bottom of Range

[Datatellsall2]

Hello,

I was wondering if there is a way to jump to the bottom of a cell range if you have blanks in between. Please see my example below, as I would like to get from 5 to 4 in one shortcut. I know Ctrl + down arrow goes to the end of the cell range if there are no blanks, but was hoping to get to the very bottom (4 in this example) if there are blanks.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
Matt

 

[lrobbo314]

Easy with VBA.

Sub GTB()

Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select

End Sub

Then you can Hit Alt+F8 and click 'Options' to create your own keyboard shortcut to access it.