Auditing Macro

[EOAEvan]

Is there a function in Excel or can a macro be written to be able to click on cell and have it read the formula and determine the precedents and actuall move to that cell so i would be able to view the formula in that cell then click a "ok" button or something and then it will move on to the next precedent cell. I know of the auditing arrows but this still requires alot of manual looking for the refernece.

Reason I ask is i have to audit a very complex workbook that one cell may have a chain of 10 precedents or more. The auditing arrows help but when it references another sheets I just get the box that shows it is from another sheet.

any ideas?

 

[GlennUK]

If you register with Aaron Blood's website, you'll be able to download his Explode tool, which should do what you want. See here:
http://www.xl-logic.com/index.php

 

[Peter_SSs]

The auditing arrows help but when it references another sheets I just get the box that shows it is from another sheet.

any ideas?

Try double clicking the dotted line that joins "the box" to your cell. That should make navigating to the relevant cell(s) in the next sheet easier.

Edit: This also might be worth a quick look to to see if it is any use (scroll up on the linked page to see the original question)
http://www.mrexcel.com/board2/viewtopic.php?p=1424863#1424863