Identify precedents to cell in/outside of activesheet
 

Hello:

Need help with a piece of VBA code to identify if the
selected cell has any direct precedents outside of the
activesheet.

e.g.
a) Cell A1 (is on Sheet2) has formula "=Sheet1!A1*C2"

b) Cell A1 (is on Sheet2) has
formula "=NamedRange*C2", 'NamedRange' is a named range
refering to Cell A1 on Sheet1

Both these versions of formulas have precedents outside
the activesheet. Would like code to verify if any
external reference exists.

Your help is appreciated, Thanks in advance.
-Neil

Identify precedents to cell in/outside of activesheet
 

Neil,

If you are interested in saving some time, this routine is in my XspandXL
add-in. As are external dependents, circular refs in and across sheets, and
full tracing diagnostics. It's on my site. You would think it was a trivial
exercise, but if it was I guess I wouldn't have spent all that time writing
it!

Robin Hammond
www.enhanceddatasystems.com

"Neil Bhandar" wrote in message
...
Hello:

Need help with a piece of VBA code to identify if the
selected cell has any direct precedents outside of the
activesheet.

e.g.
a) Cell A1 (is on Sheet2) has formula "=Sheet1!A1*C2"

b) Cell A1 (is on Sheet2) has
formula "=NamedRange*C2", 'NamedRange' is a named range
refering to Cell A1 on Sheet1

Both these versions of formulas have precedents outside
the activesheet. Would like code to verify if any
external reference exists.

Your help is appreciated, Thanks in advance.
-Neil