Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Clear Method

Clear Method

 

Deletes every chart in the chart workspace and resets all the formatting to the default values.

expression.Clear

expression   An expression that returns a ChartSpace object.

Deletes all formatting and data from the specified range.

expression.Clear

expression   An expression that returns a  Range object.

Example

This example deletes all charts in the specified chart workspace.

ChartSpace1.Clear

This example clears the range B2:C4 on the active worksheet in Spreadsheet1.

Spreadsheet1.ActiveSheet.Range("B2:C4").Clear 

 

Show:
© 2015 Microsoft