Trace Precedents

Hello,

I'm fairly new to programming in VB and need some direction. I am trying to figure out the formula for some (300) cells on a worksheet. The formulas are complex and involve tracing cells back and forth between multiple worksheets. I am dealing with a large workbook with around 30 sheets. Is there some way I can write a macro to trace precedents and record all of the references of the calculation?

I'll try to explain an example here... sorry if its confusing.
For example: (Trying to Find Worksheet2.E3 formula) Worksheet2.E3 = Worksheet15.B35 and the formula for that cell is =($B$40-$G$16)/$E$16 where Worksheet15.B40 = Worksheet2.E2 which is derived from a input on Worksheet1.B46. Worksheet15.G16 is an input on Worksheet1.G44. Worksheet15.E16 is also an input on Worksheet1.D44.

Any help is greatly appreciated. Thank you.

Problem: I have been given a workbook with about 30 pages that contain many formulas. There is an input page where data is inputted and the formulas are derived off of these inputs. There is an output page that has values derived from an input that goes through many formulas and pages. The output page contains informaiton that is to be inputted into a computer program.

I need to trace the values from the output page all of the way back to the input page that contains the original input information. So far my way of going about this is to see if it is possible to write a macro that goes to a cell and does trace precedents all of the way through the formula(s) to find the original cell/input, while recording the cells in the formula. Sort of like a Explode Add-In and Evaluate Formula that Steps-In until it cannot go any futher (Input page). I am also wondering if something can paste or display the input/original cell and automatically trace for multiple cells. Sorry if this is confusing.

If there was a way to automatically used Explode for a list of cells that would be a great step in the right direction.

Any help is appreciated thanks.

I have used the explode add-in. The only problem is that I have to manually find the input and manually paste the formula.

Is there a way to automate the explode add-in to find and paste precedents of multiple cells (ex: find precedents of cells C1:C50) without having to do manually click on and explode every individual cell?