Dependents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What VBA function returns cell 2 from which cell 1 gets its value? 7
Export Sheet Values to new workbook 20
Auditing function dehanced? 2
Has Microsoft fixed Excel's Dependents bugs? 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
WorksheetFunction.Match Usage? 9
Trace Dependents not working 3
Conditional Formatting Challenge 3

Back
Top