Has Microsoft fixed Excel's Dependents bugs?

[baobob]

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 are:

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.

***

 

[Jim Rech]

I don't think things have improved at all in any patches or new version.

With regard though to UDFs I suspect that NavigateArrow, etc. violates the
rule that VB functions called from a worksheet formulas (UDFs) cannot "take
actions".

--
Jim
|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 are:
|
| 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.
|
| ***

 

[Charles Williams]

As a matter of pure curiosity, why would you want to determine dependents
from within a UDF?

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm