title: loop copy paste randomly leaving out data
body: <p>has anyone had an issue in excel vba where a loop to copy and paste rows and check for certain criteria sometimes leaves out information and after i try to debug and run through it works fine</p>
  
  <p>I have a loop</p>
  
  <pre><code>For rnum = 3 To LastRow
      'if all cells are equal to the Comboboxes then copy and paste the row
      ThisWorkbook.Activate
  
      If Sheets("Revised Budget").Cells(rnum, 1).Value = BUval And _
              Sheets("Revised Budget").Cells(rnum, 2).Value = TeamLocVal And _
              Sheets("Revised Budget").Cells(rnum, 3).Value = YrVal And _
              Sheets("Revised Budget").Cells(rnum, 9).Value = InstVal Then
  
          Sheets("Revised Budget").Range(Cells(rnum, 1), Cells(rnum, 12)).Copy
          NewWkbk.Sheets("Actual").Activate
  
          If NewWkbk.Sheets("Actual").Range("A1").Offset(1, 0).Value = "" Then
              NewWkbk.Sheets("Actual").Range("A1").Offset(1, 0).PasteSpecial
          Else
              NewWkbk.Sheets("Actual").Range("A1").End(xlDown).Offset(1, 0).PasteSpecial
          End If
  
          Application.CutCopyMode = False
  
      End If
  
  Next rnum
  </code></pre>