ClearFormats Method

Applies To

ChartArea object, ErrorBars object, Floor object, LegendKey object, PlotArea object, Point object, Range object, Series object, Trendline object, Walls object.

Description

Clears the formatting of the object.

Syntax

expression.ClearFormats

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

See Also

Clear method, ClearContents method.

Example

This example clears all formatting from cells A1:G37 on Sheet1.

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

This example clears the formatting from embedded chart one on Sheet1.

Worksheets("Sheet1").ChartObjects(1).Chart.ChartArea.ClearFormats