ClearContents Method

  • Article

ClearContents method as it applies to the ChartArea object.

Clears the data from a chart but leaves the formatting.

expression.ClearContents

ClearContents method as it applies to the Range object.

Clears the formulas from the range.

expression.ClearContents

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