Range.AutoOutline Method (Excel)
Automatically creates an outline for the specified range. If the range is a single cell, Microsoft Excel creates an outline for the entire sheet. The new outline replaces any existing outline.
Syntax
expression .AutoOutline
expression A variable that represents a Range object.
Return Value
Variant
Example
This example creates an outline for the range A1:G37 on Sheet1.
Note
The range must contain either a summary row or a summary column.
Worksheets("Sheet1").Range("A1:G37").AutoOutline