Applies To
Button Object, Buttons Collection, DrawingObjects Collection, GroupObject Object, GroupObjects Collection, Range Object, Style Object, TextBox Object, TextBoxes Collection.
Description
True if text with the distributed text alignment style has extra space added at the beginning and end of each line. Read-write.
Remarks
This property is available only in Far East versions of Microsoft Excel, and only works for text with the xlDistributed alignment style in the direction of the text (indent is added if the text Orientation is xlVertical and the VerticalAlignment is xlDistributed, or if the text Orientation is xlHorizontal and the HorizontalAlignment is xlDistributed).
See Also
HorizontalAlignment Property, Orientation Property, VerticalAlignment Property.
Example
This example sets cell A1 on Sheet1 to use distributed horizontal alignment with extra space at the beginning and the end.
With Worksheets("Sheet1").Range("A1")
.HorizontalAlignment = xlDistributed
.AddIndent = True
End With