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