Export (0) Print
Expand All

Range.AutoOutline Method

Office 2007
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   A variable that represents a Range object.

Return Value
Variant

Example

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

Bb209687.vs_note(en-us,office.12).gif  Note
The range must contain either a summary row or a summary column.
Visual Basic for Applications
Worksheets("Sheet1").Range("A1:G37").AutoOutline



Community Additions

ADD
Show:
© 2014 Microsoft