How to get a function in VBA to return NA?

[VBADummy]

I searched this in the boards and could not find an answer. If it has been covered, I am sorry. I am new to the board.

How do you get a function that you write in VBA to return an excel NA()? I have tried almost everything and can not get it to work.

Thanks

 

[Andrew Poulsom]

Welcome to the Board.

Example:

Function MyFunc(arg) As Variant
    If IsNumeric(arg) Then
        MyFunc = arg * 2
    Else
        MyFunc = CVErr(xlErrNA)
    End If
End Function

For other possibilites check out the XlCVError constants in the Object Browser.

 

[VBADummy]

Thank you very much!