Range.InsertIndent method (Excel)

Adds an indent to the specified range.

Syntax

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.

Remarks

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.

Example

This example decreases the indent level in cell A10.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.