Oct 29 2020 01:41 PM
Is it possible to trace dependents/precedents for formulas in multiple cells at once? Or do you have to select individual cells and "trace dependents" from the Formula Auditing Group menu, one at a time?
Oct 29 2020 02:26 PM
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:
Sub ShowPrecedents()
Dim rng As Range
For Each rng In Selection
rng.ShowPrecedents
Next rng
End Sub
Oct 29 2020 02:51 PM
Thanks Hans, I'll give that a try.