Trace Dependents

When using the auditing tool, trace dependents. If the arrow points to
another worksheet, is it possible to determine in which sheet of the
workbook the dependent cell exists?

If you double click on that line/arrow to the mini worksheet symbol, you'll see
a list of all the other ranges.

George Tattam wrote:
>
> When using the auditing tool, trace dependents. If the arrow points to
> another worksheet, is it possible to determine in which sheet of the
> workbook the dependent cell exists?

--

Dave Peterson

Thanks for your help Dave.

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> If you double click on that line/arrow to the mini worksheet symbol,
> you'll see
> a list of all the other ranges.
>
> George Tattam wrote:
>>
>> When using the auditing tool, trace dependents. If the arrow points to
>> another worksheet, is it possible to determine in which sheet of the
>> workbook the dependent cell exists?
>
> --
>
> Dave Peterson