Range.IndentLevel Property (Excel)

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 .IndentLevel

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 15 in cell A10.

With Range("A10") 
 .IndentLevel = 15 
End With