title: vba auto increment a number?
body: <p>i am trying to insert a reference number into a cell in excel using vba. I want a prefix text of 'V0000' followed by an auto incremented number starting from 836. </p>
  
  <pre><code>so for each row that gets inserted I will have V0000836
  Then V0000837
  etc
  </code></pre>
  
  <p>A large portion of my code creates a new row and inserts data into it automatically one after the other, but instead of posting my whole code I am just wanting to focus on this one line of code which inserts value into column AA of my spreadsheet. I am using the following but it just gives me V00001 each time. can someone show me how I can get my code to do what I want it to. </p>
  
  <pre><code>ws2.Range("AA" &amp; DestRow).Value = "V0000836" &amp; Value + 1
  </code></pre>