ClearFormats Method

Microsoft Excel Visual Basic

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