VBA Code for selecting row

[Guest]

Ok I know how to write the code for selecting a row. Here is an example:
Rows("8:27").Select

What if instead of the number i want to use vairables such as:
Rows("x:y").Select

Can anyone tell me how to do this? If you can please email
(e-mail address removed)

 

[Ron de Bruin]

Try this

x = 3
y = 10
Rows(x & ":" & y).Select

 

[Dana DeLouis]

Just some other options:

Sub Demo()
Dim x, y
x = 3
y = 10
Range(Rows(x), Rows(y)).Select
' or
Rows(x).Resize(y - x + 1).Select
End Sub