title: Excel macro - for loop increment
body: <p>I've looked but can't find a solution.</p>
  
  <p>How do you increment a variable? Like in any other language you just do ++(variable name) just before the end of the loop. In my example, I'd like to increment J. </p>
  
  <pre><code>Dim j as integer
  j = 13
  FinalRow = Range("B15").End(xlUp).Row
          For i = 9 To FinalRow
              Range("B" &amp; i).Copy Destination:=Sheets("Design").Range("A" &amp; j)
              J++
          Next i
  </code></pre>
  
  <p>The code loops from B9-B15 and pastes the information in the Designsheet from A13 and downwards.</p>