[VBA] Condition to check if (merged) cell is in error

[Snypa]

Hello,

I have the following code:

If Not Intersect(Target, Range("C8:D8")) Is Nothing And Range("C8").Value <> "" And Not IsError(Range("C8").Value) Then

The code runs when the cell is selected but I do not want it to run if the cell shows an error.
I tested this when the cell showed #NAME error and the VBA throw a type mismatch exception. Please could anyone offer a a better solution?

 

[Fluff]

Try

If Intersect(Target, Range("C8:D8")) Is Nothing Then Exit Sub
If IsError(Range("C8").Value) Then Exit Sub
If Range("C8").Value <> "" Then
   'do something
End If