Tracing Dependents/Precedents

Question

Is it possible to trace dependents/precedents for formulas in multiple cells at once?&nbsp; Or do you have to select individual cells and "trace dependents" from the Formula Auditing Group menu, one at a time?

hansvogelaar · Answer

tommy67&nbsp;
You have to select the cells one by one and click Trace Precedents.
But you could use this macro to trace dependents for all cells in the selection:
&nbsp;
Sub ShowPrecedents()
    Dim rng As Range
    For Each rng In Selection
        rng.ShowPrecedents
    Next rng
End Sub

tommy67 · Answer

HansVogelaar&nbsp;Thanks Hans, I'll give that a try.

Forum Discussion

Tracing Dependents/Precedents

2 Replies

Resources