'================================================= ====================
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