excel vba quickest way to clear sheet contents
'VBA methods to quickly clear a sheet. 'Remove values 'but not formatting: Sheet1.UsedRange.ClearContents 'Remove formatting 'but not values: Sheet1.UsedRange.ClearFormats 'Remove everything: Sheet1.UsedRange.Clear 'Remove everything potentially faster: Sheet1.UsedRange.Delete 'Remove everything, fastest: With Application .Calculation = xlManual .ScreenUpdating = False Sheet1.UsedRange.Delete .ScreenUpdating = True .Calculation = xlAutomatic End With
