IFERROR for ver. 2003

Hi,

I tried the proposed UDF (in the hereunder thread) and it works fine as long as it is placed in a module inside the active VB.

When I receive a WB which was saved as XSLX format it shows: _xlfn.IFERROR with the correct result, but when I enter the formula for editing and hit Enter, it gives the #NAME error.

Also, when I put it into my PERSONAL.XLS and/or BOOK.XLT - it returns #NAME?

How can I use this UDF in Excel 2003 to avoid that error ?
(I do not want to install the compatibility add-in).

http://www.excelforum.com/excel-gene...ml#post2357528

Thanks, Elm