I have a strange situation and I do not what to do about it.
I have two fields
Dim A As Double
Dim B As Double
In my code I am accumulating values from Excel cells and then I am doing a comparison of A and B.
With the 'Add Watch' facility in the debugger I have
A = -3263.18
B = -3263.18
In my code the following check returns true:
If A <> B
I added a new field x = A - B
and this contains the value
4.54747350886464E-13
This makes no sense to me
Can anybody please help me out here? The code works OK in a VB6 application.
I have two fields
Dim A As Double
Dim B As Double
In my code I am accumulating values from Excel cells and then I am doing a comparison of A and B.
With the 'Add Watch' facility in the debugger I have
A = -3263.18
B = -3263.18
In my code the following check returns true:
If A <> B
I added a new field x = A - B
and this contains the value
4.54747350886464E-13
This makes no sense to me
Can anybody please help me out here? The code works OK in a VB6 application.