title: How do I increment cell in Excel VBA script?
body: <p>I have a data in excel which I want to make a VBA script to copy it into a new worksheet but in a different way.
  For example, I have this in sheet1 in A1~A3 cells.</p>
  
  <pre><code>Adam(A1)
  Sam(A2)
  Smith(A3)
  </code></pre>
  
  <p>I want to use these cells and create the following in another worksheet using refedit control.</p>
  
  <pre><code>Adam(A1)
  Adam(A2)
  Adam(A3)
  Adam(A4)
  Sam(A5)
  Sam(A6)
  Sam(A7)
  Sam(A8)
  Smith(A9)
  Smith(A10)
  Smith(A11)
  Smith(A12)
  </code></pre>
  
  <p>I have refedit control in place in VBA script, but I'm not sure how to increment cell numbers to make it copy and paste into a new worksheet. I would like to use refedit control so that I can assign any cells and make it copy and repeat itself. How do I do this in VBA script?</p>