ClearFormats Method
Office XP
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
