title: Reset a for loop when a condition is met vba
body: <p>I want to reset a counter in a loop every time a condition is met.</p>
  
  <p>Here my code : </p>
  
  <pre><code>Set report = Workbooks("Rapports").Worksheets("Relevé_" &amp; Client &amp;  "_" &amp; Datereport2)
  For i = 1 To 11 'pas auto
      VM1 = report.Range("G" &amp; i + 11).Value
      VM2 = report.Range("H" &amp; i + 11).Value
       If VM1 = 0 And VM2 = 0 Then
       report.Rows(i + 11 &amp; ":" &amp; i + 11).Delete
       End If
  
       Next
  end sub
  </code></pre>
  
  <p>When the row is deleted i want to restart i at 1, until no more cell = 0.
  Also, i dont want to delete rows where there is an empty cell.</p>
  
  <p>Thank you !!</p>