How to propagate xlErrNull back to Excel formula?
Function testit must be declared As Variant for it to be able to return
error values.
Function testit(arg) As Variant
In general, I usually end up declaring UDFs (User-Defined Functions) as
Variant anyway, just to allow for returning error values, if needed.
--
Regards,
Bill Renaud
|