Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine the number of outline levels using vba
Hi Folks,
Does anyone know if it possible to count the number of levels in an Excel worksheet outline using code? For example in the same way you may count rows using "ActiveSheet.UsedRange.Rows.Count". I want to use this feature to assist with showing and hiding grouped rows in a protected worksheet. TIA! Jamie |
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) | |||
Determining number of Outline levels | Excel Programming | |||
outline...hide levels | Excel Programming |