How to 'Trace dependents' for all cells in a selection at once?

  • Thread starter Thread starter Dmitriy Kopnichev
  • Start date Start date
D

Dmitriy Kopnichev

Hello
How to 'Trace dependents' for all cells in a selection at once?
 
Hi
I saw this post at least 4 times (2 times in this newgroup
and 2 times in a different nG - think it was Excel.misc).
Not sure if you crossposted

My answer was that AFAIK this is NOT possible.
 
Sub ShowDependents()
'
For Each cell In Selection
cell.ShowDependents
Next cell
End Sub


Sub ShowPrecedents()
'
For Each cell In Selection
cell.ShowPrecedents
Next cell
End Sub
 
Thanks!
Ken Wright said:
Sub ShowDependents()
'
For Each cell In Selection
cell.ShowDependents
Next cell
End Sub


Sub ShowPrecedents()
'
For Each cell In Selection
cell.ShowPrecedents
Next cell
End Sub


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------------------------- --
Click to expand...
 
You must log in or register to reply here.

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

What is ray tracing ? 1
Trace Dependents doesn't work (precedents does!) 4
Trace Dependents 2
Trace Precedents /dependents in another sheet 5
how can I find out trace dependents on other pages 3
how do trace dependents for all cells at once? 4
Fastest ways to trace formulas (especially when cells link to otherworksheets) 4
Call Macro if no Dependents 1

Back
Top