| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining number of Outline levels
When columns are grouped, a variant is assigned to the Outline.ShowLevels
argument for ColumnLevels (e.g., ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2). I need to run a macro that determines the number of levels there are on an activesheet. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining number of Outline levels
You would have to loop through the appropriate rows or columns and check the
OutlineLevel property of the range. Keep track of the highest number. -- Regards, Tom Ogilvy "Keith" wrote in message ... When columns are grouped, a variant is assigned to the Outline.ShowLevels argument for ColumnLevels (e.g., ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2). I need to run a macro that determines the number of levels there are on an activesheet. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outline(grouping) more than 8 levels | Excel Discussion (Misc queries) | |||
| Subtotal error to expand Outline Levels | Excel Discussion (Misc queries) | |||
| "Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
| outline...hide levels | Excel Programming | |||
| Auto generation of 3 levels of running number | Excel Programming | |||
Linear Mode
