Determine the number of outline levels using vba

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Think you have to loop through the rows and check the outlinelevel property.
Find the largest one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine the number of outline levels using vba 2
Outlining based on level numbers in most left column 3
Macro to Outline based on Indent Level 3
Counting number of grouped/outlined rows 1
How to programmatically determine which rows are outlined using Excel VBA code 1
Outline, expand or collapse via VBA 1
Outlining with condition? part 2 7
Are there any events for outlines functionalities? 2

Back
Top