Skip to main content

Range.AutoOutline method

Table of contents
  1. Syntax
  2. Return value
  3. Example

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.

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>