trace all precedents or dependents
Dave,
There is the
ActiveCell.ShowDependents False
which adds the next level of dependents' arrow each time you call it.
I don't see an easy way to know when you have reached the end though.
NickHK
"Dave F" wrote in message
...
Hi,
Is there some code I can use to automatically trace all precedents or
dependents of a cell?
I.e., a macro or module which I can assign to a button?
|