All of a sudden I am getting a Type Mismatch error on the following first section of code and can not figure out why? The code has been running fine for the last week????
Can you suggest something?
If Application.Evaluate("=MATCH(LEFT(B15,12),LEFT(FIIS,12),0)") Then
MsgBox "Careful Sensitive Client", vbOKOnly, "Sensitive Client"