I have this code:
The problem is that the mismatch if always being reported even when the values are identical.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
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
Bookmarks