View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default UDF Returning an Error Value: How to?

Is there a method of having a UDF return a "real" Excel error value such as
#NUM! ? In other words, the value returned should give a TRUE result from the
ISERR and/or ISERROR and/or ISNA worksheet functions (depending on the error)
and also give the correct response to the ERROR.TYPE worksheet function?

Thanks.


--ron