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 |
Specifies the way the shapes in the specified shape range are to be aligned. |
|
RelativeTo |
Required |
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