Range.ClearFormats (Excel) Clears the formatting of the object. Worksheets("Sheet1").Range("A1:G37").ClearFormats