ShapeRange.Align method (Excel)
Aligns the shapes in the specified range of shapes.
Syntax
expression.Align (AlignCmd, RelativeTo)
expression A variable that represents a ShapeRange object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| AlignCmd | Required | MsoAlignCmd | Specifies the way that the shapes in the specified shape range are to be aligned. |
| RelativeTo | Required | MsoTriState | Not used in Microsoft Excel. Must be False. |
Example
This example aligns the left edges of all the shapes in the specified range in myDocument with the left edge of the leftmost shape in the range.
Set myDocument = Worksheets(1)
myDocument.Shapes.SelectAll
Selection.ShapeRange.Align msoAlignLefts, False
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.