Hello Excel Forum,
In my range of E10-E1250, I need to find values lower than 0.9 and remove the entire row if found.
Here's my simple loop that does the job most of the time:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because your post count is low and the code is just a snippet. --6StringJazzer
The problem with it however is that after the row get's removed, the next row gets lifted up, and if the cell E in that row has the value of less than 0.9, it doesn't get removed because the loop moves on to the next row.
So if i run this loop on the below range...
E10 - 4.0
E11 - 0.1
E12 - 0.2
E13 - 0.3
E14 - 0.4
E15 - 0.5
E16 - 0.6
E17 - 0.7
E18 - 4.2
i'm ending up with:
E10 - 4.0
E11 - 0.2
E12 - 0.4
E13 - 0.6
E14 - 4.2
and what i need is:
E10 - 4.0
E11 - 4.2
How can i modify the exsisting loop so it gives me the desired result? Or, is there a better way to achive it perhaps? Would appreciate any help.
Bookmarks