returning NA from VBA (UDF)

[TomCon]

If i want the return value from a UDF (in VBA) to be NA (same as if i had entered =NA() in the cell), what do i assign the function value to?

Thanks,
tom

 

[Trebor76]

Hi Tom,

Assuming the variable type is a variant, try this:

'Your variant variable name' = CVErr(xlErrNA)

HTH

Robert

 

[TomCon]

Heh, great, thanks! I have generally declared these UDFs as returning Double to the Excel sheet. Is there any difference between declaring the function return type as Double vs. Variant? Or, will all the calculations work out the same once the value is in the Excel grid?

Thanks again for this nice tidbit!

Tom

 

[Andrew Poulsom]

To return an error the function's return type must be a variant:

http://www.cpearson.com/excel/ReturningErrors.aspx