ShapeRange.Align Method

  • Article
Excel Developer Reference

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 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.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
myDocument.Shapes.SelectAll
Selection.ShapeRange.Align msoAlignLefts, False

See Also