Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference list
Hi all,
using excel 2007 If a cell has precedents and dependants ~ If I click on trace dependents once, it will show arrows to direct dependants If I click trace dependents more than once (till it beeps) it will expand the arrows to all indirect dependancies Is it possible to write a macro to show all dependancies in a list Skinman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference list
You could use something like this:
Sub PrecedentCells() Dim I As Long Dim cell As Range I = 1 Selection.Precedents.Select For Each cell In Selection Cells(I, 3) = cell.Address I = I + 1 Next cell End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Skinman" wrote: Hi all, using excel 2007 If a cell has precedents and dependants ~ If I click on trace dependents once, it will show arrows to direct dependants If I click trace dependents more than once (till it beeps) it will expand the arrows to all indirect dependancies Is it possible to write a macro to show all dependancies in a list Skinman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference list
Thank you very much
works a treat just what I required Regards Skinman "Shane Devenshire" wrote in message ... You could use something like this: Sub PrecedentCells() Dim I As Long Dim cell As Range I = 1 Selection.Precedents.Select For Each cell In Selection Cells(I, 3) = cell.Address I = I + 1 Next cell End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Skinman" wrote: Hi all, using excel 2007 If a cell has precedents and dependants ~ If I click on trace dependents once, it will show arrows to direct dependants If I click trace dependents more than once (till it beeps) it will expand the arrows to all indirect dependancies Is it possible to write a macro to show all dependancies in a list Skinman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference List | New Users to Excel | |||
How Can I reference a the * cell in a list? | Excel Programming | |||
List Reference | Excel Programming | |||
Removing a reference from the LIST | Excel Programming | |||
How to reference list using a drop down menu, displaying the list | Excel Programming |