How to return Excel errors from VBA?
How can I return Excel errors such as #NUM from a VBA function?
I cannot seem to call ERROR.TYPE() from VBA (e.g.
Application.WorksheetFunction...).
Right now, I return #VALUE by a kludge: assigning 1e308 to a type
Long variable. I could do something similar to return #DIV and
perhaps #REF.
But I would prefer to do thinks more cleanly and self-documenting; and
I would like the flexibility of returning other errors.
|