title: move range of rows down in vba
body: <p>I am trying to select the first 7 rows of my spreadsheet (the exact number could vary) and move it 32 rows down (number of rows to move down could also vary). Could someone help me with the code? I have tried:</p>
  
  <pre><code>Worksheets("Report").Cells(x1, 5).EntireRow.Offset(32, 0).Select
  </code></pre>
  
  <p>I also tried</p>
  
  <pre><code>for i = 1 to 7
  set x1 = worksheets("Report").Cells(i, 5)
  Rows(x1).EntireRow.Offset(32, 0).Select
  </code></pre>
  
  <p>Won't work either. Thanks in advance for the help!</p>