Range.AutoOutline Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Concepts

Other resources

Show: