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.