title: Fill a range of cells based on another cell but continue the numerical series of numbers 7,8,9...
body: <p>This is the code that I'm currently using. But I want it to take the numerical value that it's grabbing from A2 and increase it by 1 as it fills in the range of ColN. This would create a series of numbers instead of all being the same number.</p>
  
  <pre><code>Order = Range("A2")
  
  Range("N2").Select
  ActiveCell.FormulaR1C1 = Order
  Range("N2").Select
  Range("N2", Range("N2").End(xlDown)).Name = "typeColRange"
  Selection.AutoFill Destination:=Range("N2:N" &amp; Range("A" &amp; Rows.count).End(xlUp).Row)
  </code></pre>