Checking cell for Dependents

[ExcelMonkey]

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 ar
inputs. The test will say:

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

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

Thn

 

[keepITcool]

'=====================================================================
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
mailto://[email protected]

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.