Determining number of Outline levels

[Keith]

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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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?