VBA/Excel 97 Cell Dependents/Precedents
Posted on 2003-03-25
Hi, I'm working on a macro that would graphically mark the cells within a given sheet that have either at least one precedent or at least one dependent cell.
I used the Cells.DirectDependents/DirectPrecedents.Count property to test the condition, but this works
for the active sheet only. Apparently, the Precedents/Dependents located on different sheets than the active one are not included within the Count (though I can invoke them using the Dependents/Precedents
menu bar button).
I replaced the Precedents.Count test with the Cells.HasFormula test, which works fine, but I can't find
any workaround for the Dependents case.
Any ideas would be appreciated.