Precedent/Dependent in VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Does anyone know how to find ones on other sheets?
Click to expand...
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
Click to expand...
(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
 
Back
Top