Selecting Range help

[Dannyh1]

Hi

I am trying to select a range by starting from last row up to a fixed row

I have

Range("A65536").Select
Selection.End(xlUp).Select

To get my last row

Range(Selection, Selection.End(xlUp)).Select

Would not give me what I need as the fixed range I need it to go up to is A11.

Appreciate advise on correct code.

Thanks.

 

[Michael M]

Try

Sub pick()
Dim lr As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
Range("A11:A" & lr).Select
End Sub

 

[Dannyh1]

excellent thanks