Share via


Shapes.SelectAll Method

Excel Developer Reference

Selects all the shapes in the specified Shapes collection.

Version Information
 Version Added:  Excel 2007

Syntax

expression.SelectAll

expression   A variable that represents a Shapes object.

Remarks

Example

This example selects all the shapes on myDocument and creates a ShapeRange collection containing all the shapes.

Visual Basic for Applications
  Set myDocument = Worksheets(1)
myDocument.Shapes.SelectAll
Visual Basic for Applications
  Set sr = Selection.ShapeRange

See Also