Macros not accurate???

Hello All,

I have made a macro which is designed to compare cells, under certain conditions. The table that i want to analyze eventually has 17500 rows. For this reason the macro has a variant in order to make a loop and test if the conditions are met for every row. I have tasted the macro many times and for different numbers, for example:

For i= 3 to 50 or
For i= 100 to 200

And everything worked perfectly.

The problem is that when i run it for all the rows or even for big number of rows( over 100-150) it seems in the results that it starts jumping rows.i can see that it does that because the outcome of the macro is to change the color of the cells according to the conditions. But when i go to the area of the problem and i run the macro again just for this part, for example:

For i=159 to 200

everything once again works excellent!

What do you think it could be the problem? is there a matter of accuracy in the macros?? if yes how can i fix it???


Thank you in advance

There's nothing wrong with the code you've posted, if there is a problem it's going to be the code within the loops.

Getting incorrect results can happen for a number of reasons - if you are comparing values then accuracy/rounding might be a cause.

A major reason for things eg ranges, columns etc being skipped is because they are being deleted at some point.

That can sort of throw the looping off a bit.