jasmith4
11-26-2014, 12:22 PM
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??
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??