Hi All..........

If someone would be so kind please.........I need code to select an entire
column based on the location of the cursor, but excluding the top eight rows,
(my frozen area)

ie: if the cursor is in B3, the selection will be B9:B65536
......if the cursor is in B36, the selection would be the same, B9:B65536
......if the cursor is in M65000, the selection would be M9:M65536

TIA
Vaya con Dios,
Chuck, CABGx3

Hi Chuck,
as follows:

Sub Test()
With ActiveSheet
.Range(.Cells(9, ActiveCell.Column), _
.Cells(65536, ActiveCell.Column)).Select
End With
End Sub

Regards
Frank
________________________________________________
Frank Arendt-Theilen, Microsoft MVP Excel
E-Mail:

How slick it is!...........exactly what I needed.........thank you much, kind
Sir.

Vaya con Dios,
Chuck, CABGx3



"Frank Arendt-Theilen" wrote:

Hi Chuck,
as follows:

Sub Test()
With ActiveSheet
.Range(.Cells(9, ActiveCell.Column), _
.Cells(65536, ActiveCell.Column)).Select
End With
End Sub

Regards
Frank
________________________________________________
Frank Arendt-Theilen, Microsoft MVP Excel
E-Mail: