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.