Skip to main content

Range.IndentLevel property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

Returns or sets a Variant value that represents the indent level for the cell or range. Can be an integer from 0 to 15.



expression A variable that represents a Range object.


Using this property to set the indent level to a number less than 0 (zero) or greater than 15 causes an error.


This example increases the indent level to 4 in cell A1.

With Range("A1")
    .IndentLevel = 4
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>