This documentation is archived and is not being maintained.

Range.InsertIndent Method

Office 2007
Adds an indent to the specified range.

Syntax

expression.InsertIndent(InsertAmount)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
InsertAmountRequiredLongThe 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



Show: