Trace Dependents

G

George Tattam

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?
 
D

Dave Peterson

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

George Tattam

Thanks for your help Dave.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My trace dependents is not working 0
VBA for Dependents shortcut menu 0
Trace Precedents /dependents in another sheet 5
Trace dependents - can it auto-update / is there a keyboard shortc 0
Fastest ways to trace formulas (especially when cells link to otherworksheets) 4
Trace Dependents doesn't work (precedents does!) 4
Reference list 2
Strange error in simple addition 2

Top