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?