how can i find all DirectPrecedents of a cell and all of the DirectPrecedents of that cell's DirectPrecedents
what i need is to collect all DirectPrecedents of a formula in excel workbook
and all of the DirectPrecedents of that cell's DirectPrecedents ( no matter how big and complex workbook is and how many sheets ) in vb runtime and add all of it to a collection or array
i am writing a VB app. that uses formulas from existing excel WB. for that if i use an excel formula i need to get ALL of its DirectPrecedents and all of the DirectPrecedents of that formula's DirectPrecedents
i am using excel XP
thanks
For VBA/Excel, please ask.