Entire column, but not top 8 rows
 

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

Entire column, but not top 8 rows
 

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:

Entire column, but not top 8 rows
 

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: