IFERROR for ver. 2003

[ElmerS]

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

[romperstomper]

If you use a UDF that is not in the same workbook or in an add-in, you must prefix it with the workbook name:
=Personal.xls!IfError(...)
for example.

[ElmerS]

Thanks a lot.

Elm

[shg]

Or add a reference to Personal.xls.

[ElmerS]

Thanks shg,

If my assumption is correct - I'll have to add such reference in every WB I get, from a third party, and this seems for me more complicated that using PERSONAL.XLS!

Elm