Range.AutoOutline Method

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. The range must contain either a summary row or a summary column.

Visual Basic for Applications
`Worksheets("Sheet1").Range("A1:G37").AutoOutline`

auto outline Auto Outline Method Automatically create an outline? AutoOutline AutoOutline Method Autooutline. Can Excel outline a table automatically? Easy way to outline a financial statement? Method for producing an outlined table?

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.

See also: