Range.ClearFormats method

Clears the formatting of the object.

Syntax

expression.ClearFormats

expression A variable that represents a Range object.

Return value

Variant

Example

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

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

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

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