vba code to remove formating from entire sheet code example Example: excel vba remove formatting from cell ThisWorkBook.Worksheets(1).Cells.ClearFormats