title: Loop increasing value by 1 each time
body: <p>I am trying to start with a value of 1 in A1 and then increase the value by 1 and move to A2, ie A1 = 1, A2 = 2 etc</p>
  
  <p>right now i only have code increasing the value in A1. How can i increase the value and drop down a cell each time?</p>
  
  <pre><code>Sub test()
  Range("A1").Value = Range("A1").Value + 1
  End Sub
  </code></pre>