I want an user defined function that also returns #NUM! as result

Hello,
I have the following macro (user defined function, for use in Excel cells):

Please Login or Register  to view this content.

The problem is marked above. I want to return the error #NUM! as Excel would do, but it seems to be impossible.
First Error: invalid formats (sure: "#NUM!" is string, the function shall give a date)
If I change the function definition

Please Login or Register  to view this content.

then I get the string (!) value #NUM! in the cell, but not the error value as Excel does (or would do).

Is it really impossible to return a built-in error from Excel with VBA?

Hi,

You may use

Please Login or Register  to view this content.

in order to return a true #NUM! error value.