ChartObjects.ShapeRange Property

Excel Developer Reference

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.

Visual Basic for Applications
  Set sr = Worksheets(1).ChartObjects.ShapeRange

See Also