Free Support Forum -



I have a problem with Cells.GroupRows.

If I group say Rows 1-20 and then want t group rows 21 -77 and then group rows 38-51

I am running this code

Cells.GroupRows(1, 20, true);

Cells.GroupRows(21, 37, true);

Cells.GroupRows(38, 51, true);

the trouble is it end up in one big group - 1 - 51

instead of three smaller groups.

Please help!



Hi Simon,

That's the routine of MS Excel. For your purpose, you have to change your code to:

Cells.GroupRows(1, 20, true);

Cells.GroupRows(22, 37, true);

Cells.GroupRows(39, 51, true);