Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ClearFormats Method

ClearFormats Method

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

 

Show:
© 2015 Microsoft