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 show dependents for all cells in a selection at once?
Hello
How to show dependents for all cells in a selection at once? |
#2
|
|||
|
|||
How to show 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 show 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 |
Thread Tools | |
Display Modes | |
|
|