Try this:

Rows(x & ":" & y).Select

only text goes in " " and variables stay out.

--
steveB

Remove "AYN" from email to respond
" 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