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