Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking cell for Dependents
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 -- ExcelMonke ----------------------------------------------------------------------- ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522 View this thread: http://www.excelforum.com/showthread.php?threadid=27618 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to trace dependents in a book at once without checking cell by | Links and Linking in Excel | |||
Checking cell for Dependents | Excel Programming | |||
Checking cell for Dependents | Excel Programming | |||
Checking cell for Dependents | Excel Programming | |||
Checking cell for Dependents | Excel Programming |