Grouping Rows with Range Variables
 

Hello.

I'm trying to create groupings by rows, but using variable integer
values in the range.

For example, if I have:

Rows("2:2007").Rows.Group

And I want to use two variables whe

nFirst = 100
nLast = 200

to designate the row values to my groupings instead of those values,
what's the correct syntax? I should know this, but I'm having issues for
some reason.

Anyone's help would be greatly appreciated.

Thanks.
Dan







*** Sent via Developersdex http://www.developersdex.com ***

Grouping Rows with Range Variables
 

Rows(nFirst & ":" & nLast).Rows.Group


--
Cheers
Nigel



"Dan G." wrote in message
...
Hello.

I'm trying to create groupings by rows, but using variable integer
values in the range.

For example, if I have:

Rows("2:2007").Rows.Group

And I want to use two variables whe

nFirst = 100
nLast = 200

to designate the row values to my groupings instead of those values,
what's the correct syntax? I should know this, but I'm having issues for
some reason.

Anyone's help would be greatly appreciated.

Thanks.
Dan







*** Sent via Developersdex http://www.developersdex.com ***