how to remove formulas in excel keeping values and formatting vba code example Example: excel vba remove formatting from cell ThisWorkBook.Worksheets(1).Cells.ClearFormats