Range.InsertIndent method (Excel)

Adds an indent to the specified range.


expression.InsertIndent (InsertAmount)

expression A variable that represents a Range object.


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

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.