rows(X & ":" & Y).Select

make sure there is a space between the variable and the ampersand.

--
Regards,
Tom Ogilvy


"Bythsx-Addagio" wrote:

Hello all,

I have the following
Rows("1:" & x).Select

But now I am trying to find the syntax for selecting rows based on two
variables.

ie.
x= upper_limit
y=lower_limit

Rows(x:y).Select

this gives me an error: Expected list seperator or )

Help please.