title: Removing rows while looping through them
body: <p>I'm trying to remove all rows form a <code>Range</code> that have a cell with value <code>"Totals"</code> in them. I tried something like this:</p>
  
  <pre><code>For Each cell In rng
      If CStr(cell.Value) = "Totals" Then
          cell.EntireRow.Delete
      End If
  Next cell
  </code></pre>
  
  <p>The problem is that whenever there are two rows both containing a cell with <code>"Totals"</code> only the first row gets removed. How can I solve that?</p>