Determining number of Outline levels

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

Guest

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?
 
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.
 
You must log in or register to reply here.

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

Grouping a range of sheets 10
Data Extract from Multiple Worksheets Macro 4
2002 vs 2007 MS Office Excel has encountered a problem and needs t 2
Excel 2000 SP3 versus Excel 2007 --error code 0Xc0000005 3
Trying to "clean up" some code... 1
Excel not showing steps as I F8 through each line of VBA code 1
Excel 2003 macro won't run in Excel 2007 5
Collapsing all groups 0

Back
Top