Range.InsertIndent Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Adds an indent to the specified range.

expression .InsertIndent(InsertAmount)

expression A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

InsertAmount

Required

Long

The amount to be added to the current indent.

Using this method to set the indent level to a number less than 0 (zero) or greater than 15 causes an error.

Use the IndentLevel property to return the indent level for a range.

This example decreases the indent level in cell A10.

With Range("a10") 
 .InsertIndent -1 
End With

Concepts

Other resources

Show: