Select range of cells in column AS based upon lastcell in col A.
 

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?

Select range of cells in column AS based upon lastcell in col A.
 

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?

Select range of cells in column AS based upon lastcell in col A.
 

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?