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


--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Bruce B" wrote in 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!