iterator - Iterate through changing range in VBA -

i iterating through range in vba, in loop. have if statement removes values range when meet criteria, when next value in range skipped.

i know can around array , iterator in java, vba have this?

you have iterate backwards when deleting rows therefore have use for loop instead of for each

you set i last row in range , add step -1 have loop decrement i

sample for each will not work properly

dim cell range each cell in range("a1:a100")     if isempty(cell) cell.delete shift:=xlup next  

a replacement for loop delete rows if empty

dim long, lastrow long, firstrow long lastrow = 100: firstrow = 1 dim cell range = lastrow firstrow step -1     set cell = range("a" & i)     if isempty(cell) cell.delete shift:=xlup     set cell = nothing next