title: How to insert a row of cells using VBA code
body: <p>My code is as follows. I have <code>Rng</code> set as a range in my looping macro, and this is a sub of that. If a certain condition is met, then the following sub is called:</p>
  
  <pre><code>Sub FKCutandPaste(Rng As Range)
  
  Rng.Resize(, 9).Cut
  Rng.Offset(, 19).Insert Shift:=xlDown
  Rng.Resize(, 9).Delete Shift:=xlUp
  </code></pre>
  
  <p>I want this to cut out a section of the data, then paste it away from the active columns. However, the macro seems to just cut out the the required cells, but doesn't move onto the second line. </p>
  
  <p>Am I missing something very small here?</p>