I want to determine if a cell has returned the #REF! Error using an if statement, I have no idea how to address this.

I've tried:

Code:

---

If [Cell] = "#REF!" Then....

---

To no avail, returns a type mismatch, any other ideas? :)

Try this:

If Evaluate("=ERROR.TYPE(" & Address & ")") = 4 Then
action code
End If

Same problem, type mismatch :/