Keyboard shortcut or selecting entire column

Which one is the ks for selecting all the cells in a column up to the last
used cell including blank cells in between?

Thanks

There isn't one AFAIK

I use a macro assigned to a button.

Sub GODOWN()
Dim maxrow As Long
With ActiveCell.Parent.UsedRange
maxrow = .Cells(.Cells.Count).Row + 1
End With
ActiveCell.Parent.Cells(maxrow, ActiveCell.Column).End(xlUp).Select
End Sub


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 08:23:02 -0700, Precious_Stone
<PreciousStone@discussions.microsoft.com> wrote:

>Which one is the ks for selecting all the cells in a column up to the last
>used cell including blank cells in between?
>
>Thanks