title: Why is this "Delete Method of Range class failed" error popping up?
body: <p>I am trying to figure out why this "Delete Method of Range Class" error is popping up.  It does not always occur when this macro runs, which makes it all the more perplexing.</p>
  
  <p>Can anybody explain this?</p>
  
  <pre><code>Sub ResetSheet()
  If WindowsOS Then
  
      '*******************************************************************************************************'
  'Resets the Data sheet.  Called by the resetSheetButton procedure (located in module: m7_Macros1_5).    '
  'Also called by the OkCommandButton_Click procedure in the OnOpenUserForm form.                         '
      '*******************************************************************************************************'
  
  Application.EnableEvents = False
  
  Sheet4.Visible = True
  Sheet4.Activate
  Sheet4.Select
  Sheet4.Rows("2:101").Select
  Selection.Copy
  
  'TC Edit
  Sheet1.Activate
  Sheet1.Range("A2").PasteSpecial (xlPasteAll)
  'Sheet1.Paste
  Sheets("Data").Select
  Sheet1.Rows("102:10000").EntireRow.Delete
  Sheet4.Visible = False
  
  'TC Edit 2.0 - Adding code to reset the exception checkboxes
  If WindowsOS Then
      Call resetCheckBoxes
  End If
  
  Application.EnableEvents = True
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/0U16s.png" rel="nofollow">This is the macro code that causes the error (sometimes)</a></p>
  
  <p><a href="http://i.stack.imgur.com/WQV4P.png" rel="nofollow">This is the error pop-up</a></p>