Hi Eric,

Hi all. I'm trying to write some code to check for precedents and dependents on other sheets. When I access it through code
(activecell.precedent for example), it seems to only catch the ones that are on the same worksheet. Does anyone know how to find
ones on other sheets?

The only way I know is to show the arrows and use NavigateArrow to find where they point to. See the findcirc routine on my web
site for an example.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk