Determine the number of outline levels using vba

's Computer Specifications

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

's Computer Specifications

Think you have to loop through the rows and check the outlinelevel property.
Find the largest one.

--
Regards,
Tom Ogilvy

"Jamie Richards" <(E-Mail Removed)> wrote in message
news:B62BF46C-50FA-40A6-A39B-(E-Mail Removed)...
> 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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I set outline levels in Table of Contents, still shows all levels	Meowzer	Microsoft Word Document Management	3	30th Jul 2008 05:40 PM
Determine the number of outline levels using vba	=?Utf-8?B?SmFtaWUgUmljaGFyZHM=?=	Microsoft Excel Programming	2	15th Oct 2006 02:29 AM
Determining number of Outline levels	=?Utf-8?B?S2VpdGg=?=	Microsoft Excel Programming	1	7th Feb 2006 07:14 PM
Number of levels for a Numbered Outline List	=?Utf-8?B?Ri4gSmFtZXMgTGl0dGxl?=	Microsoft Word Document Management	7	15th Jul 2005 04:27 PM
Re: Outline Levels	Bill Dilworth	Microsoft Powerpoint	0	22nd Jul 2004 01:30 AM