View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] baobob@my-deja.com is offline
external usenet poster
 
Posts: 100
Default DirectDependents not working properly.

My difficulties and confusion increase, not decrease.

If A1 has 1+ dependents, then if in the VBE Immediate window I type
Range("MySheet!A1").DirectDependents.Count, I get a correct answer.

But:

1) If A1 has no dependents, then the expression throws an error (1004)
instead of answering "0". Why?

2) When the same expression is used in my FUNCTION, then, whether A1
has dependents or not, it a) always produces spurious value 1, and b)
never throws an error.

What is all this illogical behavior?

Thanks.

***