Clear Method

Clear method as it applies to the ChartSpace object.

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.

Clear Method as it applies to the Range object.

Deletes all formatting and data from the specified range.

expression.Clear

*expression   * An expression that returns a Range object.

Example

As it applies to the ChartSpace object.

This example deletes all charts in the specified chart workspace.

ChartSpace1.Clear

At is applies to the Range object.

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

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

Applies to | ChartSpace Object | Range Object

See Also | ClearContents Method | ClearFormats Method | Delete Method