ExcelBanter - Checking cell for Dependents

'================================================= ====================
NOTE: when replying from ExcelForum/ExcelTip be aware that other users
relying on NNTP will not be informed of your replies!

ExcelTip/ExcelForum's script for handling replies is faulty and is in
violation of RFC 1036 - Standard for interchange of USENET messages - as
they do not include the REQUIRED REFERENCES field in the message header
(article 2.2.5 of the RFC)

'================================================= =====================

If you are a user from ExcelTip/ExcelForum
please contact your webmaster

again and again and again
until he does something about this !!!

'================================================= =====================

ExcelMonkey,

Ok. that makes it clearer.

I assume you're testing for precedents iso Specialcells(xlConstants)
because you have "input" cells which are in fact formulas?

="MyText" iso myText
=123*2 iso 246

else using speciallcells would be much quicker.
Q: is this correct?

Unfortunately Excel's (direct)precedents/dependents is a crippled method
as it will only test the dependency tree on the SAME sheet.

Q: Can you live with a "simple" test DirectDependents/Precedents on the
"SAME" sheet?

As already indicated in previous posts the tracearrow method CAN be very
slow..If you have many dependents.

I dont know wow often you'd need to run this check/ or how universal
your function must be..

An alternative approach would be to copy the sheet to new workbook..
and THEN check for external links.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

ExcelMonkey wrote in message
:

Yes I am looking for a test (boolean) to see IF is has a dependent,
What I am doing is testing to see which cells in my spreadsheets are
inputs. The test will say:

If Hasprecedents(Range) = FALSE And If Hasdependenets(Range) = TRUE
Then
IsInput = TRUE

I was using your code to do the dependent part of the test.

Thnx