ClearFormats Method From Microsoft Office Web Components Visual Basic previous page next page Deletes all formatting from the specified range. expression.ClearFormats expression An expression that returns a Range object.ExampleThis example clears the formatting from all cells on the active worksheet.Spreadsheet1.ActiveSheet.Cells.ClearFormats