If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
How to 'Trace dependents' for all cells in a selection at once?
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 |
#4
|
|||
|
|||
How to 'Trace dependents' for all cells in a selection at once?
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 |
#5
|
|||
|
|||
How to 'Trace dependents' for all cells in a selection at once?
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? . |
#6
|
|||
|
|||
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? . |
Thread Tools | |
Display Modes | |
|
|