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

  • Thread starter Thread starter jonnybrovo815
  • Start date Start date
J

jonnybrovo815

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
 
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,
 
Back
Top