Grouping Rows with Range Variables

D

Dan G.

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 where:

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 ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type Mismatch Error in Excel VB on RowIndex 1
Looking for specific text Value in cell 2
Inserting variable outputs into different ranges 2
Change variable value of -1 to 1 5
Variable types 9
Adding Variables to a range with quotes 4
Pass a variable into a range? 1
Macro to Create Name Ranges for variable lengths of Data 9

Top