Trace Precedents / Dependents

  • Thread starter Thread starter Steven Revell
  • Start date Start date
S

Steven Revell

Hi all,

I am trying to get a range or collection of all the
precedents / dependents for a cell. The
activecell.precedents will only return a range if the
precedents are on the same worksheet.

I need to get a list of all the ones on different
worksheets.

Thanks for any help,
Steven
 
Back
Top