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.

Visual Basic for Applications 
With Range("a10") .InsertIndent -1 End With
Change the number of indents in a particular cell? Decrease all indents in a range by one? insert Insert a specified number of indents into a table? Insert Indent Insert Indent Method InsertIndent InsertIndent Method

See also: