SUMM with gHOST!!!!

[sal21]

peraphs Hans just have post a solution for the prob in image, but i dont found...

in effect in debug print the 2 var are exactlly the same but th IF statement not WORK!!!!!!!!!!!!

note:
all var are dimensioned Double

[HansV]

What happens if you use

Debug.Print DIFFERENZA - SALDO

Do you get 0?

[sal21]

What happens if you use

Debug.Print DIFFERENZA - SALDO

Do you get 0?

-3,63797880709171E-12 (??????????????????)

[HansV]

That means that DIFFERENZA and SALDO are almost equal but not quite: there is a difference of 0.0000000000036...
Change the line

If DIFFERENZA <> SALDO Then

to

If Abs(DIFFERENZA - SALDO) > 0.0001 Then

The code will then ignore very small differences between DIFFERENZA and SALDO.

[sal21]

That means that DIFFERENZA and SALDO are almost equal but not quite: there is a difference of 0.0000000000036...
Change the line

If DIFFERENZA <> SALDO Then

to

If Abs(DIFFERENZA - SALDO) > 0.0001 Then

The code will then ignore very small differences between DIFFERENZA and SALDO.

work tkx!