Using a marco to expand ALL grouped cells

Hi Steve

To un group everything:

Thanks very much for this. It worked a treat!

Do you happen to know howI could use a similar code to then contract the rows. I tried changing your idea from 'ShowLevels' to 'HideLevels' but it did not work.

Any ideas would be appreciated...

Steve

Well, you could just call the Outline property with the Outline level set as 1:


If you have multiple levels and you want them all collapsed then I think you may have to loop thru the lot of them:

Fantastic - thank you very much!

Is there a way to expand, for example, only 2 of 5 groupings on multiple sheets? I have a workbook of about 30 sheets, with identically formatted data on each sheet (the numbers change from sheet to sheet, but not the row or column headings). Depending on how I how/to whom I want to present the data, I want 2 of my groupings expanded or collapsed. And I want this change to occur on every sheet, consistently, without having to click on each sheet, and then expand 2 groupings (lots of clicks).

Your macro appears to expand all groupings on a sheet - I only want to expand 2 of the groupings on a sheet.

I'm not sure if your macro will work on more than one sheet at once? Would you just change the code to list all worksheets? How might that look?