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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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