I have a cell that has various dependents on DIFFERENT sheets and workbooks.
How through VBA do I find all the dependents addresses and is there an
existing function to do this. Range.Dependents only refers to the existing
sheet. Can this also work for precedents?

Kt,

It's tough. You have to actually show the dependents then navigate towards
them using the link number, then log the cell, then go back to your source
cell and do it again.

Or you could use my XspandXL add-in - there's a 30 day trial on my site -
which handles all of this, plus precedents, circularity testing, dependent
chains, etc.

Robin Hammond
www.enhanceddatasystems.com

"kt" wrote in message
...
I have a cell that has various dependents on DIFFERENT sheets and
workbooks.
How through VBA do I find all the dependents addresses and is there an
existing function to do this. Range.Dependents only refers to the existing
sheet. Can this also work for precedents?