Shapes.SelectAll Method (Excel)
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.
Example
This example selects all the shapes on myDocument and creates a ShapeRange collection containing all the shapes.
Set myDocument = Worksheets(1)
myDocument.Shapes.SelectAll
Set sr = Selection.ShapeRange