Offset or Resize Selection

[tesleen2025]

Hi,
I have the below code. I need to resize this to exclude the last row. In other words I want to keep all but the last row selected.

Range("A3:B3").Select
Range(Selection, Selection.End(xlDown)).Select


I've tried various offsets and resize combinations and can't seem to get it right.
Hoping someone can help with this.

Thank you,
Tesleen

 

[Joe4]

Here is one way:

    Dim lastRow As Long
    lastRow = Range("A3").End(xlDown).Row - 1
    Range("A3:B" & lastRow).Select

 

[JoeMo]

Try:

Range(Selection, Selection.End(xlDown).Offset(-1,0)).Select

 

[tesleen2025]

Thank you JoeMo! This was exactly what I was trying to do.

 

[JoeMo]

Thank you JoeMo! This was exactly what I was trying to do.

You are welcome - thanks for the reply.