title: For loop with range of cells within another range
body: <p>Trying to figure out what the code below is doing, but cannot figure it out:</p>
  
  <pre><code>For Each c In Sheets("Control").Range("y3:y" &amp; Range("y" &amp; 
  Rows.Count).End(xlUp).Row).Cells
  
  Sheets("forecast").Range("a5") = c
  </code></pre>
  
  <p>What I think is happening:</p>
  
  <p>Below <code>c</code> is set to a certain cell, this contains a name. In the upper part for every cell, in sheet control, for the range from <code>y3</code> till the end, .... and then the confusion starts. What happens next:</p>
  
  <pre><code>Range(".." &amp; Range(".." &amp; Rows.Count).End(x1Up).Row).Cells
  </code></pre>
  
  <p>How do I read this?</p>
  
  <p>This is the table from Sheets("Control"):</p>
  
  <p><a href="https://i.stack.imgur.com/UefDA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UefDA.png" alt="enter image description here"></a></p>