ChartObjects.ShapeRange Property (Excel)
Returns a ShapeRange object that represents the specified object or objects. Read-only.
Syntax
expression .ShapeRange
expression An expression that returns a ChartObjects object.
Example
This example creates a shape range that represents the embedded charts on worksheet one.
Set sr = Worksheets(1).ChartObjects.ShapeRange