Hi

I need to trace dependents in a range of cells rather than just one cell,
but it doesn't seem to work. Am I missing something simple? I'm using Excel
2002.

Thanks

VrB

Select the range of cells in question and then click the trace dependents
button on the formula auditing toolbar.

Works for me. How are you trying to do this? What happens when you try to
do it?
--
Brevity is the soul of wit.


"violasrbest" wrote:

Hi

I need to trace dependents in a range of cells rather than just one cell,
but it doesn't seem to work. Am I missing something simple? I'm using Excel
2002.

Thanks

VrB

The trace dependents command works only on the active cell. If doing
several cells at once is important to you you could write a macro that does
it.

--
Jim
"violasrbest" wrote in message
...
| Hi
|
| I need to trace dependents in a range of cells rather than just one cell,
| but it doesn't seem to work. Am I missing something simple? I'm using
Excel
| 2002.
|
| Thanks
|
| VrB

Dave

When I select a range of cells only the first cell in the range shows the
arrow. Jim Rech says that it only works on the active cell.

VrB

"Dave F" wrote:

Select the range of cells in question and then click the trace dependents
button on the formula auditing toolbar.

Works for me. How are you trying to do this? What happens when you try to
do it?
--
Brevity is the soul of wit.


"violasrbest" wrote:

Hi

I need to trace dependents in a range of cells rather than just one cell,
but it doesn't seem to work. Am I missing something simple? I'm using Excel
2002.

Thanks

VrB