Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trace Precedents
I would like to determine all the cells used by formula in
another cell. For example: Cell A1 contains the formula =B1+B3/B5 I would like to create a procedure to let me know that B1, B3, and B5 are used as inputs to cell A1. The idea is basically the same as Excel's "trace Precedents" feature, but instead of seeing the arrows, I would like a list of the cell addresses (note that the addresses may or may come from different worksheets)...Any ideas would be greatly appreciated. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternative for Trace Precedents | Excel Discussion (Misc queries) | |||
Trace dependants/precedents from another worksheet | Excel Discussion (Misc queries) | |||
Trace Precedents Arrows Missing | Excel Discussion (Misc queries) | |||
I want to trace the precedents in a formula when they are on mult. | Excel Discussion (Misc queries) | |||
Trace Precedents / Dependents | Excel Programming |