Or
Activecell.DirectDependents.Address

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

I sure am in a need of a formula to list the address(es) of dependent(s)
relevant to a specific cell, existing in the currently opened workbooks so as
to have quick review instead of clicking each cell, tracing the arrows and
checking the links in every new popup of an arrow.

Your expertise and aid in thi regard shal highly be obliged.

Thanx in advance!
--
Best Regards,

Faraz