title: Excel VBA - Pass a Row of Cell Values to an Array and then Paste that Array to a Relative Reference of Cells
body: <p>Using Excel (2010) VBA, I am trying to copy (pass) a constant range of cells (whose values recalculate) to an array.  Then I am trying to pass that array to a new range of cells, directly below it.  After I have done this, I want to again copy (pass) the constant range's new values to the array, and pass these new values to a range directly below the one I previously passed.</p>
  
  <p>I know this code is atrocious (I am new to arrays in VBA).</p>
  
  <pre><code>Sub ARRAYER()
  
  Dim anARRAY(5) As Variant
  
  Number_of_Sims = 10
  
  For i = 1 To Number_of_Sims
     anARRAY = Range("C4:G4")
     Range("C4").Select
     ActiveCell.Offset(Number_of_Sims, 0).Select
     ActiveCell = anARRAY
     Range("C4").Select
  Next
  
  End Sub
  </code></pre>
  
  <p>I sure do appreciate your help!</p>
  
  <p>Thank you.</p>
  
  <p>Respectfully,</p>
  
  <p>Jonathan </p>