Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 12th 08, 01:10 PM posted to microsoft.public.excel.misc
MK MK is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 57
Default 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   Report Post  
Old February 12th 08, 03:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 208
Default 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   Report Post  
Old February 12th 08, 03:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trace Precedents and dependents for a range of cell ? Anand vijay New Users to Excel 1 January 17th 07 08:02 PM
trace dependents Susan B Excel Worksheet Functions 0 November 20th 06 10:28 PM
Trace Dependents Trot Excel Discussion (Misc queries) 1 May 24th 06 05:55 PM
trace dependents JBoulton Excel Worksheet Functions 2 May 19th 05 09:04 PM
How to trace dependents in a book at once without checking cell by alisfalor Links and Linking in Excel 2 March 11th 05 07:53 AM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017