InsertIndent Method [Excel 2003 VBA Language Reference]

  • Article

Adds an indent to the specified range.

expression**.InsertIndent(InsertAmount)**

expression Required. An expression that returns a Range object.

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

Applies to | Range Collection

See Also | IndentLevel Property