Hi all,

Iam kartik. Iam trying to develop a application in vb.net which finds the formula errors in a excel workbook, by tracing the prcedents of a given cell..to find the initial cell which actually causing the errors.

Iam able to track the precedents in a give activesheet. but iam not able to trace precedents if they span across other sheets in the same workbook. Also iam not able to track the the hirerarchyof the precedents till the actual error causing cell.

Iam in avery tight time crunch...Please help me...any codes and suggestionsregarding wud be very helpful and grateful


Cheers,
Kartik