ClearFormats Method [Excel 2003 VBA Language Reference]
Clears the formatting of the object.
expression**.ClearFormats**
expression Required. An expression that returns an object in the Applies To list.
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
Applies to | ChartArea Object | ErrorBars Object | Floor Object | LegendKey Object | PlotArea Object | Point Object | Range Collection | Series Object | Trendline Object | Walls Object
See Also | Clear Method | ClearContents Method