Print list of linked cells within a tab?? Is it possible?

[Rasec]

Hi,

I have a 40 tab model which has formulas that pull from other tabs. Is there a way to ask excel to look/loop through a worksheet and highlight the cells that have precedents and dependents & list the names of the tab's being referenced in the worksheet?????

Can someone help me with this? maybe there is a VBA code that can help me audit this 40 tab model.


Any suggestions on how I can start the learning process?

THANKS GUYS!

 

[Derek Brown]

A couple of add-ins come to mind but they are not free.

Power Utility Pak from J Walk, but I don't think that this will give you exactly what you are looking for:
http://spreadsheetpage.com/index.php/pupv7/home

Spreadsheet Detective but this is certainly not for the faint-hearted:
http://www.spreadsheetdetective.com/
http://www.spreadsheetdetective.com/advanced-features.htm#Precedent

 

[Evan R.]

The best spreadsheet auditing program that I've found is The Audinator (http://www.audinator.com). Much better accuracy and thoroughness than some of the other ones. It's a little more money but the time saved and errors caught make up for it.