Range of Rows

[123FakeSt]

What's the easiest way to set a range to variable rows?

Rather than:
Set xlRng = Rows("1:4")

I need it to be dynamic:

iStartRow = 1
iEndRow = 4

Set xlRng = Rows(iStartRow:iEndRow)

Thanks!

The early bird gets the worm, but the second mouse gets the cheese.

 

[123FakeSt]

OK I figured it out .. it's

Set xlRng = Rows(iStartRow & ":" & iEndRow)

Thanks

The early bird gets the worm, but the second mouse gets the cheese.

 

[SkipVought]

Hi,

A slightly better way, rather than formatting a string, is

Set xlRng = range(Rows(iStartRow), Rows(iEndRow))

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}