Hi
I am comparing two ranges of exactly the same size and prompting the
result as either a complete match or a mismatch even if one value
differs between the ranges. I tried:

Sub comp()
Dim FirstRange As Range, SecondRange As Range

Set FirstRange = Application.InputBox("Set first series: ", Type:=8)
Set SecondRange = Application.InputBox("Set Second series: ", Type:=8)

If Evaluate("SUM((EXACT(FirstRange,SecondRange)=FALSE )*1)") = 0 Then
MsgBox "Ranges are exact"
Else
MsgBox "Ranges differ"
End If
End Sub

This does not work and gives an error on "If Evaluate..." line. Could
someone help please.

I am also wondering if it can accomodate when one or both the values
are #NA type of errors.

Thanks
Utkarsh