title: Iterate through changing range in VBA
body: <p>I am iterating through a range in VBA, currently in a for loop. I have an if statement that removes values from the range when they meet certain criteria, however when i do this the next value in the range is skipped.</p>
  
  <p>I know I can get around this with an array and an iterator in Java, does VBA have anything like this?</p>