Range.AutoOutline Method (Excel)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

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.

expression .AutoOutline

expression A variable that represents a Range object.

Return Value

Variant

This example creates an outline for the range A1:G37 on Sheet1.

Note Note

The range must contain either a summary row or a summary column.

Worksheets("Sheet1").Range("A1:G37").AutoOutline
Show:
© 2016 Microsoft