title: Quickest way to clear all sheet contents VBA
body: <p>I have a large sheet that I need to delete all the contents of. When I try to simply clear it without VBA it goes into not responding mode. When using a macro such as:</p>
  
  <pre><code>Sub ClearContents ()
   Application.Calculation = XlManual
   Application.ScreenUpdating = False
  
    Sheets("Zeroes").Cells.ClearContents
  
   Application.ScreenUpdating = True
  End Sub
  </code></pre>
  
  <p>It also doesn't respond. What's the quickest way to do this?</p>