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.

Dim lRow As Long
    
lRow = Cells.Find(What:="*", _
    After:=Range("J1"), _
    LookAt:=xlPart, _
    LookIn:=xlValues, _
    SearchOrder:=xlByRows, _
    SearchDirection:=xlPrevious, _
    MatchCase:=False).Row
                    
If Range("J" & lRow).Value <> Range("K" & lRow).Value Then
    ActiveSheet.Range("J" & lRow & ":" & "K" & lRow).Select
    MsgBox "Check Mapping"
    'Exit Sub
Else
End If
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!