title: VBA Code in Excel randomly stops executing. No error messages occur
body: <p>Essentially, I have an Updata button that takes information from two columns, in two spreadsheets (within 1 book). The overall goal of this code is to take all the values from one column, and then append the values from the other column below it.</p>
  
  <pre><code>Worksheets("Overall Flow").Range("A4:A1004").Value = Worksheets("Active").Range("A2:A1002").Value
  Dim i As Integer
  For i = 4 To 1004
      If Worksheets("Overall Flow").Range("A" &amp; Trim(str(i))) = "" Then
          Worksheets("Overall Flow").Range("A" &amp; Trim(str(i)) &amp; ":A" &amp; Trim(str(1000 + i))).Value = Worksheets("Inactive").Range("A2:A1002").Value
          i = 1005
      End If
  Next
  </code></pre>
  
  <p>For some reason, the first line executes, and then finishes. When I put break points, then do step-by-step, no other steps happen afterwards.</p>
  
  <p>When I run the first line individually, it  appears to work fine, but not when:</p>
  
  <pre><code>Worksheets("Overall Flow").Range("A" &amp; Trim(str(i)) &amp; ":A" &amp; Trim(str(1000 + i))).Value = Worksheets("Inactive").Range("A2:A1002").Value
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Worksheets("Overall Flow").Range("A4:A1004").Value = Worksheets("Inactive").Range("A2:A1002").Value
  </code></pre>
  
  <p>is present aftwards.</p>