Perhaps you mean Jan Karel Pieterse's RefTreeAnalyser:
http://www.jkp-ads.com/RefTreeAnalyser.asp
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thanks Nick - I was aware of that tool within Excel. My apologies for not
| being more specific. I ran across some VBA code that an individual had
| developed to debug/step through/etc. large rather complex IF statements. I
| just can't remember where I saw it at. It's just a more robust version of
| the Auditing Tool in Excel.
|
| Again, thanks.
|
| BJ
|
| "Niek Otten" wrote:
|
| > It depends on what you mean with "review".
| > The Tools>Formula Auditing commands (like Evaluate Formula) may already help you a lot.
| > Otherwise, specify what you require.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Hi All
| > |
| > | I have some really large and complicated IF statements (formula type, not
| > | VBA) that I need to review.
| > |
| > | I seem to recall a VBA tool someone created to do this, but I can't find a
| > | link in my favorites.
| > |
| > | Any thoughts?
| > |
| > | Thanks.
| > |
| > | BJ
| >
| >
| >