Selecting Variable Rows

[Matt D.]

Hello,

I am attempting to get some code to work that looks like:

X = X + 95
Y = Y + 95
Rows("X:Y").Select

Basically I need to to be able to change the values of the
rows I need to select. I cant find anything in help, so
could someone help me with the syntax.

Thanks

Matt D.

 

[Ron de Bruin]

Hi Matt

Try this

Rows(X & ":" & Y).Select

 

[Tom Ogilvy]

X = X + 95
Y = Y + 95
Rows(X & ":" & Y).Select

 

[Dana DeLouis]

Just two other ideas. If X is always less than Y:
Rows(X).Resize(Y - X + 1).Select

If not, than another idea:
Range(Cells(X, 1), Cells(Y, 1)).EntireRow.Select

Dana DeLouis