title: Remove item during for loop
body: <p>What does <code>tlist</code> contain after I do:</p>
  
  <pre><code>Dim tlist As Collection
  tlist.Add ("AA")
  tlist.Add ("BB")
  tlist.Add ("CC")
  tlist.Add ("DD")
  
  For i = 1 To tlist.Count
      If i = 2 Then tList.Remove (2)
  Next
  </code></pre>
  
  <p>I am hoping it will be:</p>
  
  <pre><code>Index | Value
  -------------
  1     |  "AA"
  3     |  "BB"
  4     |  "CC"
  </code></pre>
  
  <p>But I fear it will be:</p>
  
  <pre><code>Index | Value
  -------------
  1     |  "AA"
  </code></pre>
  
  <hr>
  
  <hr>
  
  <p>This is what my code looks like so far:</p>
  
  <pre><code>Dim tlist As Collection
  tlist.Add ("KA")
  tlist.Add ("KIC")
  tlist.Add ("KS")
  tlist.Add ("NC")
  
  ' Loop through each cell in row.
  For Each mycells In myrow.Columns
      Dim i As Integer
  
      ' Loop through each regex in list.
      For i = 1 To tlist.Count
          matches = Regex(tlist(i))
  
          ' If match found in cell, copy row, and remove element (to prevent duplicate rows).
          If matches &gt;= 1 Then
              Call CopyRow(myrow, _
                           ActiveSheet.Index, _
                           ActiveSheet.Index + i)
  
              tlist.Remove (i)
          End If
      Next
  Next
  </code></pre>
  
  <p>Is <code>Collection</code> even the right data type to use?</p>