UDF Fails when recalculation is initiated from a different workbook

[Atom]

This is the code:

Please Login or Register  to view this content.

As long as I'm in the workbook where this function exists, it returns correct values. If I go to a different book and force a recalculation, then the function returns #VALUE!

[6StringJazzer]

How are you calling it from the other workbook?

[Atom]

The other workbook does not use the UDF in any way, and the UDF does not refer to cells in the other workbook. The UDF is just in a single workbook.

[6StringJazzer]

Oh, I see, you have a UDF defined and used in one workbook, but when a different workbook, which has nothing to do with the UDF, is recalculated, the UDF returns #VALUE.

I have never seen that problem. Is there anything unusual about either file? How are you forcing recalculation--hitting F9, or in code?

[Atom]

I changed this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

and that worked.

[romperstomper]

I strongly suggest you revisit your post from yesterday, read post #2 from MrShorty and then implement it. It will save you a lot of problems like this in the future.

[Atom]

Ordinarily, I would do as suggested, but this particular UDF has non obvious inputs which never change. Thanks for the help.