Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
There are three objects that represent shapes: the Shapes collection, which represents all the shapes on a document; the ShapeRange collection, which represents a specified subset of the shapes on a document (for example, a ShapeRange object could represent shapes one and four on the document, or it could represent all the selected shapes on the document); and the Shape object, which represents a single shape on a document. If you want to work with several shapes at the same time or with shapes within the selection, use a ShapeRange collection.
This section describes how to:
Return an existing shape.
Return a shape within the selection.
Return the shapes attached to the ends of a connector.
Return a newly created freeform.
Return a single shape from within a group.
Return a newly formed group of shapes.
Returning an Existing Shape
Use Shapes(index), where index is the shape name or the index number, to return a Shape object that represents a shape.
Each shape is assigned a default name when you add it to the Shapes collection. To give the shape a more meaningful name, use the Name property.
Returning a Shape Within the Selection
Use Selection.ShapeRange(index), where index is the shape name or the index number, to return a Shape object that represents a shape within the selection.
Returning the Shapes Attached to the Ends of a Connector
Returning a newly created freeform
Returning a Single Shape from Within a Group
Use GroupItems(index), where index is the shape name or the index number within the group, to return a Shape object that represents a single shape in a grouped shape.
Returning a Newly Formed Group of Shapes
Use the Group or Regroup method to group a range of shapes and return a single Shape object that represents the newly formed group. After a group has been formed, you can work with the group the same way you work with any other shape.