Applies To
Outline Object.
Description
Displays the specified number of row and/or column levels of an outline.
Syntax
object.ShowLevels (rowLevels, columnLevels)
object
Required. The Outline object (ActiveSheet.Outline, for example).
rowLevels
Optional. Specifies the number of row levels of an outline to display. If the outline has fewer levels than specified, Microsoft Excel shows all levels. If omitted or zero, no action is taken on rows.
columnLevels
Optional. Specifies the number of column levels of an outline to display. If the outline has fewer levels than specified, Microsoft Excel shows all levels. If omitted or zero, no action is taken on columns.
Remarks
You must specify at least one argument.
Example
This example displays row levels one through three and column level one of the outline on Sheet1.
Worksheets("Sheet1").Outline.ShowLevels rowLevels:=3, columnLevels:=1