AutoOutline Method
Applies To
Range object.
Description
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 Required. An expression that returns a Range object.
See Also
ApplyOutlineStyles method, ClearOutline method, DisplayOutline property, Group method, Outline object, OutlineLevel property, ShowDetail property, Ungroup method (Range object).
Example
This example creates an outline for the range A1:G37 on Sheet1. The range must contain either a summary row or a summary column.
Worksheets("Sheet1").Range("A1:G37").AutoOutline