Dynamic Row Selection

[Bruce B]

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

 

[Don Guillett]

try

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

Rows(r & ":" & r).Select

 

[Tom Ogilvy]

rows(6).Select

works as well,

rw = 6
rows(rw).Select

Regards,
Tom Ogilvy

 

[Matt Lunn]

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

 

[Bruce B]

The variable was an integer.

I think the first two replies should work.

Thanks for the help!

- Bruce