What's the data type of r.value? Was the error a 1004?
-----Original Message-----


I'm trying to select rows based on a parameter passed to
the sub
procedure that selects the row.

I know if I want a set row then I could do:

Rows(6:6).Select

However, let's say I have a parameter r that contains
the row number I
want to select.

I tried:

Rows(r.Value + ":" + r.Value).Select

However, this just gives me an error.

Any help would be appreciated.

Thanks!

- Bruce

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.