Keyboard shortcut or selecting entire column

P

Precious_Stone

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
 
G

Gord Dibben

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
 
Top