Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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:
© 2015 Microsoft