Export (0) Print
Expand All

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



Community Additions

ADD
Show:
© 2015 Microsoft