Skip to main content

Range.InsertIndent method

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>