Iterate and Update same Collection in VBA
<p>My requirement is to iterate through a VBA collection , and based on certain
condition update the subsequent records in the same collection.</p>

<p>For example lets say "TMasterList" is a collection which has total of 4 records , 
while 2nd record gets processed in the below loop,
I need to update 3rd and 4th record and then continue with the loop(ie process 3 and 4th).</p>

<pre><code>For Each objEachTmapping In TMasterList


Next
</code></pre>

<p>Any suggestions on how to implement it.</p>