ClearContents Method

         Example         Applies To

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.