I just spent a miserable 3 days trying to do something very simple in
VBA and failed.

I want to determine whether a cell has dependents or not. All
dependents, on the same sheet and external. In a UDF.

Some things I think I learned a

1. In Office XP Excel VBA, <Range.Dependents, DirectDependents,
ShowDependents, etc. work in Subs but fail in Functions.

2. Microsoft has crippled UDFs on a number of counts.

3. Dependents/DirectDependents only return references in the same
sheet; external references are omitted. But ShowDependents works
correctly.

4. NavigateArrow has "an anomaly in which a cell with no dependents
returns itself ad infinitum" (per one very helpful thread).

5. Chip Pearson has reported at least one of these issues to
Microlite. Thank God for people like him. Like truckers of days of
yore, they're the knights of the programming road.

6. Also, since you need to NavigateArrows, there may not be a direct,
"for each" method to cycle through dependents...? In the absence of a
working dependents property, newsgroup examples I've seen seem to use
On Error constructions.

I offer you up a cheerful, muffled: Agghhhh!!!

Has Microflot fixed these problems--most importantly, the UDF one?

Thanks.

***