+ Reply to Thread
Results 1 to 2 of 2

WHy so hard to get a cell's formula dependents and precedents??

  1. #1
    Registered User
    Join Date
    01-14-2011
    Location
    N/A
    MS-Off Ver
    Excel/Access/Word 2010
    Posts
    11

    WHy so hard to get a cell's formula dependents and precedents??

    I've been working on code which traverses a cell's formula dependents (precedents too -- please assume both throughout), and it seems Microsoft fights you all the way! If a cell's dependent is on a different tab, the cell's Dependents property yields an error! But you CAN use ShowDependents and then NavigateArrow -- but only if the tab that has the dependent is visible: what if it's hidden? And forget it if it's in a different file, and the file isn't open. Yet Excel's UI can put up a list of the dependents if you double-click the external-dependent arrow, so it must be possible to get a list of all dependents.

    The only way I've found to get a complete list is to set up a double-loop, one for arrow number, one for external-link index, and keep trying NavigateArrow until the selection doesn't move. But again, each dependent's tab has to be visible, and each relevant file has to be open.

    Is there REALLY no way of just getting a list or collection of dependents, which, if empty, would have a Count/CountLarge property equal to zero? Really, Microsoft??

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: WHy so hard to get a cell's formula dependents and precedents??

    Perhaps you could use the RefTreeAnalyzer offered at this website:
    http://www.jkp-ads.com/RefTreeAnalyser.asp

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trace Dependents / Precedents arrow
    By CC_ITA in forum Excel General
    Replies: 0
    Last Post: 03-28-2014, 04:44 AM
  2. Listing Precedents/Dependents in a list box
    By learning2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2012, 05:21 PM
  3. Precedents and Dependents
    By roy1987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2009, 03:19 AM
  4. trace all precedents or dependents
    By Dave F in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2006, 11:00 PM
  5. [SOLVED] Trace Dependents and Precedents not working
    By Manish in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1