Trace Precedents / Dependents
 

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

Trace Precedents / Dependents
 

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

--
Regards,
Tom Ogilvy

"Steven Revell" wrote in message
...
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