title: Looping Code/Skipping Rows
body: <p>I have the following in a piece of VBA code:</p>
  
  <pre><code>For i = 1 To 5
      myArray(i) = i + 0
  Next i
  For i = 6 To 8
      myArray(i) = i + 1
  Next i
  For i = 9 To 14
      myArray(i) = i + 2
  Next i
  </code></pre>
  
  <p>...etc</p>
  
  <p>There must be a better way to do this, but for the life of me I cannot think of one. Could anyone help? Perhaps something with the Select..Case syntax?</p>
  
  <p>Edit: these are actually supposed to be various sub-divisions of areas in the company. the lines I am 'skipping' are automatically calculated totals of said areas.</p>