Row / column selection syntax

I am trying to select a series of rows from row 3 to row "row", where "row" is a variable.

i.e. some variant of

Rows.select("3:row")

....
perhaps.

Any help is greatly appreciated. Thanks a lot.

Let r be some calculated row number, then

Rows("3:" & r).Select

Try this :

Sub test()
    Range("3:" & Range("A1").Value).EntireRow.Select
End Sub

Where Range A1 contains the last rownumber of the ranges you want to select.

Erik

In most cases it is unnecessary to actually select ranges in VBA.