title: Setting Range in For Loop
body: <p>I am trying to set the range in For loop. My code works fine when I do this:</p>
  
  <pre><code>For Each i in Range("A1":"A5")
     'Some process code
  Next i
  </code></pre>
  
  <p>But I do not get the same results when I do this:</p>
  
  <pre><code>For Each i in Range("A1").End(xlDown)
      'Some Process
  Next i
  </code></pre>
  
  <p>Arent the two codes equivalent? What changes should I make to the second one that it perfoms the same way as the first one but doesn't make me hardcode the Range in the code?</p>