Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
working with grouped rows and columns
Hi all
I have worksheets whith rows and columns grouped over several levels. I now want to expand or collapse these grouped rows/columns based on certain criteria (i.e. not simply all groups on a certain level as in ActiveSheet.Outline.ShowLevels RowLevels:=5). Is it at all possible to get a "handle" on a specific group node, e.g. ActiveSheet.Outline.RowLevels(5,1).Hidden = True Thanks for any suggestion. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collapse grouped rows and columns on opening workbook | Excel Discussion (Misc queries) | |||
Shortcut for hide/show detail in grouped columns/rows | Excel Discussion (Misc queries) | |||
Grouped columns & rows | Excel Worksheet Functions | |||
How do I open or close grouped columns/rows in a protected excel s | Excel Discussion (Misc queries) | |||
Grouped Columns/Rows | Excel Worksheet Functions |