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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trace Precedents
Highlight your (formulized) cells and then hold down the Control Key an
simultaneously press the title key (that is the key to the left of the 1 (one) key on the top row - It becomes a toggle type thing - pressing again turns off.. HTH "Hawk" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trace Precedents
I want to do it in a procedure, but thanks for the tip. I
need to do some further processing based on what the input cells contain...Any other ideas??? -----Original Message----- Highlight your (formulized) cells and then hold down the Control Key an simultaneously press the title key (that is the key to the left of the 1 (one) key on the top row - It becomes a toggle type thing - pressing again turns off.. HTH "Hawk" wrote in message ... 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 . |
Reply |
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 |