Behavior for some functions is different when used as a function in a cell -
Special cells for one. Find in xl2000 and earlier (doesn't work). This is
one of them. I can't say why.

As you have stated, precedents and directprecedents and dependents and
directdependents do not work off sheet. The workaround is to use the Excel4
macro approach of follow arrows I believe. Stephen Bullen uses that
technique in his utility to find circular errors.

http://www.oaltd.co.uk/Excel/Default.htm

--
Regards,
Tom Ogilvy

"scattered" wrote in message
oups.com...


Tom Ogilvy wrote:
Note that this function will not return correct results if used in a
worksheet cell such as

=RefersToBlanks(B10)
(snip)
Regards,
Tom Ogilvy



Thanks for pointing this out.

Why doesn't the function work in a worksheet cell? I know that you
can't put functions with side effects (like message boxes) in a cell,
but I don't see any side effects in my function. Is the problem with
recursion as such?

Another problem with my function is that it doesn't work with
precedents in another sheet. Is there any work around? (The approach
using Precedents instead of DirectPrecedents has the same problem)

Have a good day

-John Coleman