Export (0) Print
Expand All

Range.ClearFormats Method

Office 2007
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:G37 on Sheet1.

Visual Basic for Applications
Worksheets("Sheet1").Range("A1:G37").ClearFormats

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

Visual Basic for Applications
Worksheets("Sheet1").ChartObjects(1).Chart.ChartArea.ClearFormats



Community Additions

ADD
Show:
© 2014 Microsoft