You can either use the .Dependents property, but as Peter said, this only
works with references within the sheet,
or you can use .ShowDependents followed by .NavigateArrow, which will
include off-sheet dependents.

warning: .showDependents and .NavigateArrow are a bit slow, if performance
is an issue look at only doing it once for similar blocks of formulae (use
R1C1 mode to find similar formulae).

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

wrote in message
...
I just need to know whether a cell has dependents, yea or nay; I don't
need to identify them.

Thanks.

***