I want to write the macro to know the list of all precedents and dependents
of a cell. At the same time I also want to count the no. of Precedents of a
cell from the same sheet and from the other sheet separately.
For this i am using Activecell.precedents.count( ) but it is giving me the
list of precedents only on the same sheet.

Please help me out on this.