View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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