ClearFormats Method

Deletes all formatting from the specified range.

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