ExcelBanter - Determining number of Outline levels

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Determining number of Outline levels (https://www.excelbanter.com/excel-programming/352673-determining-number-outline-levels.html)

Keith

Determining number of Outline levels

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?

Tom Ogilvy

Determining number of Outline levels

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.

--
Regards,
Tom Ogilvy

"Keith" wrote in message
...
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?

All times are GMT +1. The time now is 11:17 AM.