This documentation is archived and is not being maintained.

Shapes.SelectAll Method

Office 2007
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



Show: