title: VBA to Clear Template not Deleting Everything?
body: <p>I wrote a macro to clear the data of an excel template I use every day.  I put copied images and text into the template, save it and then the next day use the macro to clear it and repeat the process.  I've noticed after a month or two the file has become extremely large for what it contains.  It was about 50KB and is now 18,317KB with about the same amount of data.  The increase was gradual, not immediate.  Probably a few hundred KB a day.</p>
  
  <p>I've checked to see if there is any formatting in the cells and there isn't.  I think my code deletes all of the cells in each sheet except for the last (which contains very little data), but I'm not sure if it is working.</p>
  
  <pre><code>Sub Reset_Template()
      Dim WS_Count As Integer
      Dim I As Integer
      WS_Count = ActiveWorkbook.Worksheets.Count - 1
  
      For I = 1 To WS_Count
      Sheets(I).Select
      If ActiveSheet.AutoFilterMode Then
      Cells.AutoFilter
      End If
      Sheets(I).Select
      ActiveSheet.DrawingObjects.Select
      Selection.Delete
      Cells.Select
      Range("C67").Activate
      Selection.Delete Shift:=xlUp
      Cells.Select
  
      Next I
  
      Sheets(1).Select
      Cells.Select    
  End Sub
  </code></pre>
  
  <p>Is my macro somehow not deleting all of the contents of my template? Or could it be something to do with the spreadsheet's settings?</p>
  
  <p>Thank you.</p>