ClearContents Method
Applies To
ChartArea object, Range object.
Description
Clears the formulas from the range. Clears the data from a chart but leaves the formatting.
Syntax
expression.ClearContents
expression Required. An expression that returns a ChartArea or Range object.
Example
This example clears the formulas from cells A1:G37 on the datasheet but leaves the formatting intact.
myChart.Application.DataSheet.Range("A1:G37").ClearContents
This example clears the chart data from a chart but leaves the formatting intact.
myChart.ChartArea.ClearContents