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

[Dmitriy Kopnichev]

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

 

[Frank Kabel]

Hi
see your other posts
P.S.: please don't multipost

 

[Dmitriy Kopnichev]

What other posts?

Hi
see your other posts
P.S.: please don't multipost

 

[Frank Kabel]

Hi
I saw this post at least 4 times (2 times in this newgroup
and 2 times in a different nG - think it was Excel.misc).
Not sure if you crossposted

My answer was that AFAIK this is NOT possible.

 

[Ken Wright]

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

 

[Dana DeLouis]

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.aspx?scid=kb;en-us;164810&Product=xlw97

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

 

[Dmitriy Kopnichev]

Thanks!

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
-------------------------------------------------------------------------- --