how to select last range at the bottom of the column (with pic)

[Eyeson15]

hi there
I'm trying with coming up with VBA to select the last range

I googled and this selects all ranges starting from A2

Range("A2:F" & ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row).Select

The problem is I need that A2 to change dynamically.
hope my explanation is ok

james

 

[Norie]

Perhaps.

With Range("A" & Rows.Count).End(xlUp)
    Range(.Cells(1, 1), .Cells(1, Columns.Count).End(xlToLeft)).Select
End With

 

[Eyeson15]

Perhaps.

With Range("A" & Rows.Count).End(xlUp)
    Range(.Cells(1, 1), .Cells(1, Columns.Count).End(xlToLeft)).Select
End With

beautiful!