title: Excel VBA Loop to insert rows based on cell value
body: <p>Firstly the Data.</p>
  
  <pre><code>A          B
  Type 15    5
  Type 2     7
  Type 3     9
  </code></pre>
  
  <p>I need to create a loop, that starts at B1 and inserts a number of rows based on the cell value of B.</p>
  
  <p>I found the below code , but it does not loop, and i need the next cell it checks to be the result of the first cell(5) + 1 in order for it to be correct.</p>
  
  <p>**</p>
  
  <ul>
  <li>Result should be :</li>
  </ul>
  
  <p>**</p>
  
  <pre><code>A          B
  Type 1     5
  
  
  Type 2     7
  
  
  
  
  
  Type 3     9
  
  etc.
  </code></pre>
  
  <p>Thanks in advance !</p>