Reviewing Large IF Statements - Any Tools available?
 

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

Reviewing Large IF Statements - Any Tools available?
 

It depends on what you mean with "review".
The ToolsFormula Auditing commands (like Evaluate Formula) may already help you a lot.
Otherwise, specify what you require.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BJ" wrote in message ...
| 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

Reviewing Large IF Statements - Any Tools available?
 

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 ToolsFormula Auditing commands (like Evaluate Formula) may already help you a lot.
Otherwise, specify what you require.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BJ" wrote in message ...
| 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

Reviewing Large IF Statements - Any Tools available?
 

Perhaps you mean Jan Karel Pieterse's RefTreeAnalyser:

http://www.jkp-ads.com/RefTreeAnalyser.asp

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BJ" wrote in message ...
| 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 ToolsFormula Auditing commands (like Evaluate Formula) may already help you a lot.
| Otherwise, specify what you require.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "BJ" wrote in message ...
| | 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
|
|
|