expression.Distribute(Distribute, RelativeTo)
expression Required. An expression that returns one of the objects in the Applies To list.
Distribute Required MsoDistributeCmd.
MsoDistributeCmd can be one of these MsoDistributeCmd constants. |
msoDistributeHorizontally |
msoDistributeVertically |
RelativeTo Required Long. True to distribute the shapes evenly over the entire horizontal or vertical space on the page. False to distribute them within the horizontal or vertical space that the range of shapes originally occupies.
Example
This example defines a shape range that contains all the AutoShapes on the active document and then horizontally distributes the shapes in this range.
With ActiveDocument.Shapes
numShapes = .Count
If numShapes > 1 Then
numAutoShapes = 0
ReDim autoShpArray(1 To numShapes)
For i = 1 To numShapes
If .Item(i).Type = msoAutoShape Then
numAutoShapes = numAutoShapes + 1
autoShpArray(numAutoShapes) = .Item(i).Name
End If
Next
If numAutoShapes > 1 Then
ReDim Preserve autoShpArray(1 To numAutoShapes)
Set asRange = .Range(autoShpArray)
asRange.Distribute msoDistributeHorizontally, False
End If
End If
End With