VBA Code for selecting row
 

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

Try this

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


" 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

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