ClearFormats Method

Microsoft Excel Visual Basic

ClearFormats Method

       

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