Trace dependents for multiple cell
 

If I want to trace dependents for multiple selected cells in one go, I can't
do that. It takes only one cell at one time. How to do that ?

Trace dependents for multiple cell
 

I wrote these quick macros to trace up to 100 dependent /
precedents... (the 100 was chosen at random - feel free to edit it at
your discretion)

Sub Show_All_Precendents()

For i = 1 To 100
Selection.ShowPrecedents
Next i

On Error Resume Next
Application.CommandBars("Formula Auditing").Visible = True

End Sub

************************************************** ****
Sub Show_All_dependents()

For i = 1 To 100
Selection.ShowDependents
Next i

On Error Resume Next
Application.CommandBars("Formula Auditing").Visible = True

End Sub


On Feb 12, 8:10 am, mk wrote:
If I want to trace dependents for multiple selected cells in one go, I can't
do that. It takes only one cell at one time. How to do that ?

Trace dependents for multiple cell
 

Hi Tim,

I'm trying to achive the same as mk, and am using excel 07.
How do I get to the point where I can copy and paste your macro?


TIA.

"Tim879" wrote:

I wrote these quick macros to trace up to 100 dependent /
precedents... (the 100 was chosen at random - feel free to edit it at
your discretion)

Sub Show_All_Precendents()

For i = 1 To 100
Selection.ShowPrecedents
Next i

On Error Resume Next
Application.CommandBars("Formula Auditing").Visible = True

End Sub

************************************************** ****
Sub Show_All_dependents()

For i = 1 To 100
Selection.ShowDependents
Next i

On Error Resume Next
Application.CommandBars("Formula Auditing").Visible = True

End Sub


On Feb 12, 8:10 am, mk wrote:
If I want to trace dependents for multiple selected cells in one go, I can't
do that. It takes only one cell at one time. How to do that ?