title: EXCEL VBA using FOR LOOP that will disregard the step +1 LOOP COUNTER
body: <p>I am in search of a solution that will disregard or take one step back from the loop counter. Here is my code for better understanding.</p>
  
  <pre><code> Sub DownArrow5_Click()
  Dim c As Integer
  Dim copyFromRow As Integer
  
  copyFromRow = 1
  
  For c = 1 To 20
     If ActiveSheet.Rows(copyFromRow).Hidden = False And Range("A" &amp; c &amp; "").Value &lt;&gt; "" Then
     'start copy paste
      ActiveSheet.Range("A" &amp; copyFromRow &amp; ", C" &amp; copyFromRow &amp; "").Copy
      Sheets("Sheet2").Select
      ActiveSheet.Range("A1").Select
      ActiveCell.Offset(1, 0).Select
      ActiveSheet.Paste
      ActiveCell.Offset(1, 0).Select
      Sheets("Sheet1").Select
      Application.CutCopyMode = False
  
      Else
          c = 'disregard the +1 for the loop
  
     End If
   Next c   
  End Sub
  </code></pre>
  
  <p>I can't decrement the counter since it will have a negative (-) result thus returning an unending loop.</p>
  
  <p><strong>NOTE:</strong> I need to copy and paste 20 UNHIDDEN rows to sheet2. That is why I need to get the Max counter (20). This is just a brief code from what I am working on.</p>