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

Many thanks

Eric

Eric wrote:
Does anyone know how to find ones on other sheets?

Yes, but it ain't easy.
You need to use the NavigateArrow method.

If you email me at Bill_Manville @ compuserve.com (without the spaces)
I can send you some code which does something similar that you could
use as a starting point (it actually finds the source of an error value
by following on- or off-sheet links).

I cannot post it here as my client would not want it to be in the
public domain.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

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