Sign in

Home Products Office 365 Docs Samples Downloads Training How To Support Forums

Office and SharePoint development

Office client development

Office 2013

Excel 2013

Welcome to the Excel 2013 developer reference

Object model reference (Excel 2013 developer reference)

Shapes Object (Excel)

Shapes Methods (Excel)

Shapes.AddCallout Method (Excel)

Shapes.AddChart2 Method (Excel)

Shapes.AddConnector Method (Excel)

Shapes.AddCurve Method (Excel)

Shapes.AddFormControl Method (Excel)

Shapes.AddLabel Method (Excel)

Shapes.AddLine Method (Excel)

Shapes.AddOLEObject Method (Excel)

Shapes.AddPicture Method (Excel)

Shapes.AddPolyline Method (Excel)

Shapes.AddShape Method (Excel)

Shapes.AddSmartArt Method (Excel)

Shapes.AddTextbox Method (Excel)

Shapes.AddTextEffect Method (Excel)

Shapes.BuildFreeform Method (Excel)

Shapes.Item Method (Excel)

Shapes.SelectAll Method (Excel)

Minimize

This topic has not yet been rated - Rate this topic

Shapes.SelectAll Method (Excel)

Office 2013

Office 2010

Published: July 16, 2012

Selects all the shapes in the specified Shapes collection.

Version Information

Version Added: Excel 2007

expression .SelectAll

expression A variable that represents a Shapes object.

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

Concepts

Shapes Object

Other resources

Shapes Object Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.