Identify precedents to cell in/outside of activesheet

N

Neil Bhandar

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
 
R

Robin Hammond

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trace Precedents of Conditional Formatting 1
Find duplicate range or cell ref (as precedents) in a cell's formula - an example 2
VBA Code To find Hardcoded Values in Formula 5
Hyperlink to named range in workbook 1
Copy range from one sheet to another cell by cell 2
To link sheet1 cell to sheet2 three rows merged cell 6
Identify each cell that has dependents 2
Refering to a particular cell in a Named Range 3

Top