Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tracing precedents | Excel Worksheet Functions | |||
Precedents | Excel Discussion (Misc queries) | |||
Tracing precedents | Excel Worksheet Functions | |||
Range Address of Precedents and Dependents from other sheet. | Excel Discussion (Misc queries) | |||
Precedents do not work | Excel Worksheet Functions |