Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For example: Say I have a spreadsheet with 3 layers of row grouping.
Currently I'm using the following code to ungroup all 3 layers, which works for the this particular example. Selection.Rows.Ungroup Selection.Rows.Ungroup Selection.Rows.Ungroup Unfortunately the spreadsheet in question does not always have 3 layers of grouping, it may have more it may have less. Which either cause the VBA to error or not remove all the groupings. Is there any coding that will remove all groupings within a worksheet without reference to the # of layers? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ungroup workbooks into multiple instances of excel | Excel Discussion (Misc queries) | |||
Cell Groupings | Excel Worksheet Functions | |||
Excel should allow tab groupings. | Excel Discussion (Misc queries) | |||
Subtotals/Groupings | Excel Worksheet Functions | |||
Groupings | Excel Programming |