Loop expression won't recognize values are equal

[fiveironfrnzy08]

Hi all,

(Excel 2007)
The issue I'm having is that a loop statement of mine is failing to recognize that a couple values are equal. It works for the first 3 iterations of the loop, then stops recognizing. I tried copying another set of numbers in the failing one's place, and that actually worked.
I can't attach anything, so I'm including a link to a detailed screen shot with some notes on it and code that I'll host on my site.
Not sure how else to explain the issue, but if you take a look at the screen shot you can see the excel sheet being worked on and the vba code running. I will also include a text file of the code for anyone who would like to change the code to offer a suggestion.

Here are the links to the screen shot and text file of my code
Text file
Screen Shot

Thank you!

 

[NateD]

Have you checked the decimals? In the screenshot, I see that you're out to 2 decimals, but are the 3rd and 4th equal?

 

[JoeMo]

I haven't looked at your code, but just a thought, if you are basing an If statement on the equality of two numeric values you might want to round them as 54.15035 <> 54.15034 even though both appear on your sheet as 54.15, they are not equal. Try:
If Round(value1,2) =Round(value2,2) Then ...

 

[fiveironfrnzy08]

Thank you!
Round() did the trick. I thought it wasn't that because the variable watch showed them as out the same amount of decimals, but apparently not!

Thank you both for your timely assistance!