Retrieving all precedents address
 

Hi,

Is there a way to retrieve all precedents addresses, especialy precedents
that are on another sheet ?

For example, If on Sheet1 A1 I have :
=Sheet2!A1+Sheet3!A1

I want to retrieve the addresses Sheet2!A1 and Sheet3!A1

Thanks,

Retrieving all precedents address
 

Michael,

There's a suite of tracing tools in my XspandXL add-in that handles this,
dependents, circulars, errors, links, etc.

http://www.enhanceddatasystems.com/E...pandXLHome.htm

Robin Hammond
www.enhanceddatasystems.com

"Michel GLOD" <Michel wrote in message
...
Hi,

Is there a way to retrieve all precedents addresses, especialy precedents
that are on another sheet ?

For example, If on Sheet1 A1 I have :
=Sheet2!A1+Sheet3!A1

I want to retrieve the addresses Sheet2!A1 and Sheet3!A1

Thanks,