Range.AutoOutline Method (Excel)

  • 아티클

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

식 .AutoOutline

식 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.

Worksheets("Sheet1").Range("A1:G37").AutoOutline

참고 항목

개념

Range Object

Range Object Members