Workbook.Charts Property

Excel Developer Reference

Returns a Sheets collection that represents all the chart sheets in the specified workbook.

Syntax

expression.Charts

expression   A variable that represents a Workbook object.

Example

This example deletes every chart sheet in the active workbook.

Note
For the following sample code to work you must have a chart sheet in the active workbook.

Visual Basic for Applications
ActiveWorkbook.Charts.Delete

See Also

• Workbook Object
• Workbook Object Members