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

--
Dana DeLouis
Win XP & Office 2003


" wrote
in message ...
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