Reviewing Large IF Statements - Any Tools available?

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

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
 
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
 
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
 
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
| >
| >
| >
 
Back
Top