Trace Precedents / Dependents

[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

 

[Tom Ogilvy]

I believe you need to use excel4 macro commands. Stephen Bullen has such a
technique in his utility to find circular reference errors. You can
download the file from his site and examine the code:

http://www.bmsltd.co.uk/Excel/Default.htm