Export (0) Print
Expand All
Expand Minimize

Range.AddIndent Property

Office 2007
Returns or sets a Variant value that indicates if text is automatically indented when the text alignment in a cell is set to equal distribution (either horizontally or vertically.)



expression   A variable that represents a Range object.


Set the value of this property to True to autmatically indent text when the text alignment in the cell is set, either horizontally or vertically, to equal distribution.

To set text alignment to equal distribution, you can set the VerticalAlignment property to xlVAlignDistributed when the value of the Orientation property is xlVertical, and you can set the HorizontalAlignment property to xlHAlignDistributed when the value of the Orientation property is xlHorizontal.


This example sets the horizontal alignment for text in cell A1 on Sheet1 to equal distribution and then indents the text.

Visual Basic for Applications
With Worksheets("Sheet1").Range("A1")
    .HorizontalAlignment = xlHAlignDistributed
    .AddIndent = True
End With

Community Additions

© 2015 Microsoft