title: Why does "Range(...).End(xlDown).Row" return 1048576?
body: <p>I want to copy some values in a for-loop in VBA. Therefore I calculate the limits by:  </p>
  
  <pre><code>For iCounter = 1 To (Range(...).End(xlDown).Row - Range(...).Row  + 1)
  </code></pre>
  
  <p>Sadly <code>Range(...).End(xlDown).Row</code> returns <code>1048576</code>. When I debug, suddenly the value changes to the right one. The same Code works well in some other locations in the VBA Code.</p>