Clear Method

Applies To

ChartArea Object, Range Object.

Description

Clears the entire range or chart area.

Syntax

object.Clear

object

Required. The ChartArea or Range object.

See Also

ClearContents Method, ClearFormats Method.

Example

This example clears the formulas and formatting in A1:G37 on Sheet1.

Worksheets("Sheet1").Range("A1:G37").Clear

This example clears the chart area (the chart data and formatting) of Chart1.

Charts("Chart1").ChartArea.Clear