Clear Method

Applies To

ChartArea object, Legend object, Range object.

Description

ChartArea, Legend, or Range object: Clears the entire object.

ActiveX list box or combo box: Removes all entries from the list.

Syntax

expression.Clear

expression Required. An expression that returns an object in the Applies To list.

See Also

ClearContents method, ClearFormats method.

Example

This example clears the formulas and formatting in cells 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