VBA IF statement for cell values not equal not working

Hi

I have two cell values (numbers returned using formulae) which return "TRUE" when equated in Excel i.e. A1 = B1 returns "TRUE".

They also appear to be equal when I hover over the values in VBA, but the IF statement below does not work.

Please Login or Register  to view this content.

The problem is the first line of the IF statement. The two values appear to be equal but the IF statement returns True.

If I subtract the two values in VBA, I get a number with many decimal places (not zero as I would expect) but the values themselves appear to be exactly the same even with decimal places in Excel.

Thanks for any help!

How do I do that? (I would need to round to two decimal places and rounding would need to be done in VBA)

Seems to work! Thanks so much NeedForExcel!