title: Parsing an array over multiple worksheets
body: <p>I am trying to breakdown an array of tickers on one sheet into multiple sheets.  I basically am trying to for loop through multiple sheets using the "i" variable as both a worksheet identifier and also a multiplier for how many tickers go on each sheet.</p>
  
  <p>Can anyone spot the error I'm making here?  Or any other ways that you'd recommend to attack this?</p>
  
  <p>"BreakdownCount" = the user inputted grouping size...in this case 200 as a test.</p>
  
  <p>Thanks!</p>
  
  <pre><code>For i = 1 To BreakdownCount  
      UpperRange = 8 + (i - 1) * 200
      LowerRange = 8 + i * 200
      MsgBox UpperRange
      MsgBox LowerRange
  
      Worksheets("Data " &amp; i).Range(Cells(8, 2), Cells(207, 2)).Value = Worksheets("Scanner - ALL").Range(Cells(UpperRange, 2), Cells(LowerRange, 2)).Value  
  Next
  </code></pre>