How to 'Trace dependents' for all cells in a selection at once?

Hello
How to 'Trace dependents' for all cells in a selection at once?

Sub ShowDependents()
'
For Each cell In Selection
cell.ShowDependents
Next cell
End Sub


Sub ShowPrecedents()
'
For Each cell In Selection
cell.ShowPrecedents
Next cell
End Sub


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Dmitriy Kopnichev" wrote in message
...
Hello
How to 'Trace dependents' for all cells in a selection at once?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

If it's Excel 97 giving you the problem, remember this old bug ??

XL97: Run-Time Error Using ShowDependents Method
http://support.microsoft.com/default...&Product=xlw97

Dana DeLouis
(Trying to slowly recover from a serious Win XP software crash today.
Ahh!)


"Ken Wright" wrote in message
...
Sub ShowDependents()
'
For Each cell In Selection
cell.ShowDependents
Next cell
End Sub


Sub ShowPrecedents()
'
For Each cell In Selection
cell.ShowPrecedents
Next cell
End Sub


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Dmitriy Kopnichev" wrote in message
...
Hello
How to 'Trace dependents' for all cells in a selection at once?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Thanks!
"Ken Wright" wrote in message
...
Sub ShowDependents()
'
For Each cell In Selection
cell.ShowDependents
Next cell
End Sub


Sub ShowPrecedents()
'
For Each cell In Selection
cell.ShowPrecedents
Next cell
End Sub


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Dmitriy Kopnichev" wrote in message
...
Hello
How to 'Trace dependents' for all cells in a selection at once?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Dmitriy

You can do it with a macro. Press ALT + F11 to open the VB
Editor, Choose Insert Module and paste in this code.

Sub ShowAllDependents()
Dim c
For Each c In Selection
c.ShowDependents
Next
End Sub

Close the VB Editor, make your selection, and choose
Tools, Macro (ALT + F8), select the macro in the Name Box
and choose Run.

Regards
Peter
-----Original Message-----
Hello
How to 'Trace dependents' for all cells in a selection at
once?


.

Thanks!
"Peter Atherton" wrote in message
...
Dmitriy

You can do it with a macro. Press ALT + F11 to open the VB
Editor, Choose Insert Module and paste in this code.

Sub ShowAllDependents()
Dim c
For Each c In Selection
c.ShowDependents
Next
End Sub

Close the VB Editor, make your selection, and choose
Tools, Macro (ALT + F8), select the macro in the Name Box
and choose Run.

Regards
Peter
-----Original Message-----
Hello
How to 'Trace dependents' for all cells in a selection at
once?


.