vba clear entire sheet code example
Example 1: vba clear a worksheet
Sheet1.UsedRange.ClearContents
Sheet1.UsedRange.ClearFormats
Sheet1.UsedRange.Clear
Sheet1.UsedRange.Delete
With Application
.Calculation = xlManual
.ScreenUpdating = False
Sheet1.UsedRange.Delete
.ScreenUpdating = True
.Calculation = xlAutomatic
End With
Example 2: excel vba clear contents and formatting of cell with a single command
[A1].Clear
[A1].ClearFormats
[A1].ClearContents
[A1].ClearHyperlinks
[A1].ClearNotes
Example 3: excel vba quickest way to clear sheet contents
Sheet1.UsedRange.ClearContents
Sheet1.UsedRange.ClearFormats
Sheet1.UsedRange.Clear
Sheet1.UsedRange.Delete
With Application
.Calculation = xlManual
.ScreenUpdating = False
Sheet1.UsedRange.Delete
.ScreenUpdating = True
.Calculation = xlAutomatic
End With