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

Please Login or Register  to view this content.

....
perhaps.

Any help is greatly appreciated. Thanks a lot.

Let r be some calculated row number, then

Please Login or Register  to view this content.

Try this :

Please Login or Register  to view this content.

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.