title: Run-time error 1004. Method 'Range' of object '_Worksheet' failed
body: <p>I have the following 2000 lines of code that get's a compile error because the procedure is overloaded:</p>
  
  <pre><code>Sheet7.Range("H2").Value = Sheet7.Range("H2").Value + Sheet7.Range("K2").Value
  ...
  Sheet7.Range("H2001").Value = Sheet7.Range("H2001").Value + Sheet7.Range("K2001").Value
  </code></pre>
  
  <p>If I have, say, up to ten lines, it works. But I need the code to work for 2000 lines and that's when I get the compile error. To address the compile error, I used the following loop, but it gives me Run-time error 1004. Method 'Range' of object '_Worksheet' failed.</p>
  
  <pre><code>Dim RowNo as Integer
  For RowNo = 2 to 2001 Step 1
      Range(Cells(RowNo, 8)).Value = Range(Cells(RowNo, 8)).Value + Range(Cells(RowNo, 11)).Value
  Next RowNo
  </code></pre>
  
  <p>How do I make the loop work without getting a run-time error 1004?</p>