How to determine error value in cell similar to VBA.IsError

Question

I have an Excel spreadsheet. I'm trying to test whether the formula results in an error. VBA has VBA.IsError and I'm looking for an equivalent in VB.net.

    Dim CurrCell As Excel.Range = ws.Range("B10")
    CurrCell.Formula = "=DATEVALUE(-1)" 'results in #VALUE! error
    CurrCell.Select()

    'doesn't detect error
    If Microsoft.VisualBasic.IsError(CurrCell.Value) Then
        Debug.Print("error")
    Else
        Debug.Print("not error")
    End If

    'doesn't detect error; shows as VariantType.Integer
    Debug.Print(VarType(CurrCell.Value))
    If VarType(CurrCell.Value) = VariantType.Error Then
        Debug.Print("error")
    Else
        Debug.Print("not error")
    End If

How do I detect whether the result of the formula is an error using VB.net?

tried using [WorksheetFunction.IsError](https://msdn.microsoft.com/EN-US/library/office/ff835263.aspx) ? — WhiteHat, Oct 05 '15 at 16:56
@WhiteHat if you post it as an answer I'll accept it as the answer. — D_Bester, Oct 05 '15 at 17:18

score 2 · Accepted Answer · edited May 23 '17 at 12:00

This works:

    If xlApp.WorksheetFunction.IsError(CurrCell) Then
        Debug.Print("error")
    Else
        Debug.Print("not error")
    End If

But a much better solution was given by Mike Rosenblum

    Public Shared Function IsError(ByVal rgValue As Object) As Boolean
        Return TypeOf (rgValue) Is Int32
    End Function

Dealing with CVErr Values in .NET – Part I: The Problem

Dealing with CVErr Values in .NET – Part II: Solutions

How to determine error value in cell similar to VBA.IsError

1 Answers1