title: Get the value of a cell in range, store it a variable, then next cell, next row (Excel)
body: <p>I'd like to get the value of a cell in a range and store it as a variable.  And then set the value of another cell in another range as that variable. Then move on to the cell. After all the cells in the row are captured, I'd like to move to the next row and start again with the first cell and first variable. I can't figure out how to move to the next cell and then set the value in the new range to the variable. Here's what I got so far</p>
  
  <pre><code>Dim rng As Range
  Dim row As Range
  Dim cell As Range
  Dim card1 As String
  Dim card2 As String
  Dim card3 As String
  Dim card4 As String
  Dim card5 As String
  Dim valueRng As Range
  
  Set rng = Range("A2:D4")
  Set valueRng = ("F2:I4")
  
  
  For Each row In rng.Rows
   For Each cell In row.Cells
   card1 = cell.Value
   'Set first variable
   'Code here for setting value of for first cell in valueRng
  
  'Move to second cell
  'get value
  'set variable card2
  'Set value of second cell in valueRng
  
  Next cell  
  Next row
  </code></pre>