Share via

ClearFormats Method

  • Article

Deletes all formatting from the specified range.

expression.ClearFormats

*expression   * An expression that returns a Range object.

Example

This example clears the formatting from all cells on the active worksheet.

Spreadsheet1.ActiveSheet.Cells.ClearFormats

Applies to | Range Object

See Also | Clear Method | ClearContents Method