UDF FOR DEPENDENTS

[Faraz A. Qureshi]

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!

 

[Jacob Skaria]

Try this ..

Msgbox Activecell.DirectPrecedents.Address

If this post helps click Yes

 

[Jacob Skaria]

Or
Activecell.DirectDependents.Address

If this post helps click Yes

 

[Faraz A. Qureshi]

Sorry Jacob,

I have already tried that but it only returns only the address on the
current sheet and not on the others.

 

[AltaEgo]

One of the following add-ins may suit

1) Aaron Blood has an add-in named Explode.
http://www.xl-logic.com

You will need to register to obtain it:


2) http://cellmatrix.net/index.php/downloads/formula_trace_tool1/

 

[Faraz A. Qureshi]

WOW!

Xplode sure is an explosion!

Thanx Steve!!!
--
Best Regards,

Faraz

One of the following add-ins may suit

1) Aaron Blood has an add-in named Explode.
http://www.xl-logic.com

You will need to register to obtain it:


2) http://cellmatrix.net/index.php/downloads/formula_trace_tool1/