I need to select a range starting from the active cell 9 in column AS and a
variable number of rows down based upon last entered cell in column A.

Does anyone know how to go about doing this?

try

Range("AS9:AS" & Cells(Rows.Count, "A").End(xlUp).Row).Select

or do you mean upto ColA

Range("AS9:A" & Cells(Rows.Count, "A").End(xlUp).Row).Select


If this post helps click Yes
---------------
Jacob Skaria


"jonnybrovo815" wrote:

I need to select a range starting from the active cell 9 in column AS and a
variable number of rows down based upon last entered cell in column A.

Does anyone know how to go about doing this?

Sub FindLastRow()

Dim lngLastRow As Long

' find last row in Column A
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

Set rngMyRange = ActiveSheet.Range(Cells(9, "AS"), Cells(lngLastRow, "AS" ))

MsgBox rngMyRange.Address

End Sub

Hope this helps! If it does click "Yes" below.

Thanks,
--
Cheers,
Ryan


"jonnybrovo815" wrote:

I need to select a range starting from the active cell 9 in column AS and a
variable number of rows down based upon last entered cell in column A.

Does anyone know how to go about doing this?