title: Why does my vba loop skip to my outer next every time?
body: <p>So I have a double loop that for some reason always skips to my outer loop for some reason. The loop goes from:</p>
  
  <p><code>For j = lastColumn To 6 Step (-1)</code></p>
  
  <p>to: </p>
  
  <p><code>Next i</code></p>
  
  <p>every single time. However, in my data set there's a mixed variety of data which should be captured in my if statement and count the data.</p>
  
  <p>Any ideas? Maybe I formatted the macro wrongly.</p>
  
  <pre><code>Sub CheckDates()
  
  
  Dim count As Integer
  Dim i As Integer
  Dim j As Integer
  
  
  Sheets(1).Select
  
  lastrow = ActiveSheet.Cells(Rows.count, "B").End(xlUp).Row
  
  'have to keep data in a table for this to actually work as it ctrls+left to the table, which will end where the very last text of any row is
  lastColumn = ActiveSheet.Cells(1, Columns.count).End(xlToLeft).Column
  
  
  count = 0
  i = 3
  j = lastColumn
  
  For i = 3 To lastrow
      For j = lastColumn To 6 Step (-1)
          If Sheet1.Cells(i, j) &lt; Sheet2.Cells(1, 1) And Sheet1.Cells(i, j - 1) = "Reçu" Then
          count = count + 1
      GoTo NextIteration
          End If
      Next j
      NextIteration:
  Next i
  
  Sheet2.Cells(1, 7) = count
  
  Sheets(2).Select
  
  
  'Runs the DeleteSAC Macro
  Call DeleteSAC
  
  End Sub
  </code></pre>