I have this code:

PHP Code: 
    wsheet.Range("B9") = "=SUM(B5:B8)"
    
wsheet.Range("C9") = "=SUM(C5:C8)"
    
    
If wsheet.Range("B9") <> wsheet.Range("C9"Then
       wsheet
.Range("D9") = "<=== Mismatch - fix this"
       
wsheet.Range("D9").Font.Color vbRed
       End 
If 
The problem is that the mismatch if always being reported even when the values are identical.

I've tried adding .Value to the If wsheet.range("xx").value without success - I'm sure it is something trivial.

Thanks for your help