UDF FOR DEPENDENTS
 

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

UDF FOR DEPENDENTS
 

Try this ..

Msgbox Activecell.DirectPrecedents.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

UDF FOR DEPENDENTS
 

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

UDF FOR DEPENDENTS
 

Sorry Jacob,

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

--

Best Regards,

Faraz


"Jacob Skaria" wrote:

Try this ..

Msgbox Activecell.DirectPrecedents.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

UDF FOR DEPENDENTS
 

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/down...a_trace_tool1/


--
Steve

"Faraz A. Qureshi" wrote in
message ...
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

UDF FOR DEPENDENTS
 

WOW!

Xplode sure is an explosion!

Thanx Steve!!!
--
Best Regards,

Faraz


"AltaEgo" wrote:

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/down...a_trace_tool1/


--
Steve

"Faraz A. Qureshi" wrote in
message ...
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