Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trace Precedents and dependents for a range of cell ? | New Users to Excel | |||
trace dependents | Excel Worksheet Functions | |||
Trace Dependents | Excel Discussion (Misc queries) | |||
trace dependents | Excel Worksheet Functions | |||
How to trace dependents in a book at once without checking cell by | Links and Linking in Excel |