I was surprised to find there was no way to display dependencies arrows for a selection using the Formula Auditing tool bar. I don't use it a lot, but I would have though that this is the sort of thing it should be able to do. Now, I also know that there are quite a few decent Auditing tools out there which properly give you loads of feature that Excel does ship with, but it's simple enough to tap in some VBA to get what I wanted"¦ and here it is!
Dim cell As Excel.range
For Each cell In Selection
cell.ShowPrecedents
Next
End Sub
Sub ForumulaAduitShowDependents()
Dim cell As Excel.range
For Each cell In Selection
cell.ShowDependents
Next
End Sub
Sub ForumulaAduitShowClear()
ActiveSheet.ClearArrows
End Sub
Straight forward stuff, the result will look some thing like this:
Here's a little tip, if the arrows are too grouped up make the coloums a little wider - what an insight!
Â
Related posts:
