Hey, everyone. I'm need to differentiate between #DIV/0! errors and other errors on a regular basis. Since there is no function comparable to ISNA(), I've put together a simple UDF to serve my purpose. Here's what my ISDIV0() function looks like:

Function isdiv0(Value as String)
Dim BoValue As Boolean

    

    If Value = "#DIV/0!" Then
    BoValue = True
    Else
    BoValue = False
    End If
    isdiv0 = BoValue
    
End Function
If I point this at a cell with a #DIV/0! error, then I get a #VALUE! error. However, if I point it at a cell in which I've typed #DIV/0!, then it works perfectly. All I can figure is that errors cannot be manipulated as strings.

Can anyone help me figure out how to properly pass the error into my function? I tried digging through excel VBA object editor to see how ISNA() works, but I can't get down to the actual code.

Thanks!