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

object.ClearFormats

object

Required. The object to which this method applies.

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 of embedded chart one on Sheet1.

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