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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine the number of outline levels using vba
Think you have to loop through the rows and check the outlinelevel property.
Find the largest one. -- Regards, Tom Ogilvy "Jamie Richards" wrote in message ... 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 |
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) | |||
Determine the number of outline levels using vba | Excel Programming | |||
Determining number of Outline levels | Excel Programming | |||
outline...hide levels | Excel Programming |