ClearFormats Method

  • Article

Clears the formatting of the object.

expression.ClearFormats

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Example

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

myChart.Application.DataSheet.Range("A1:G37").ClearFormats

This example clears the formatting from the chart.

myChart.ChartArea.ClearFormats

Applies to | ChartArea Object | ErrorBars Object | Floor Object | LegendKey Object | PlotArea Object | Point Object | Range Object | Series Object | Trendline Object | Walls Object

See Also | Clear Method | ClearContents Method