Reviewing Large IF Statements - Any Tools available?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BJ - 28 May 2008 20:05 GMT

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

Reply to this Message

Niek Otten - 28 May 2008 20:13 GMT

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.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi All
|
[quoted text clipped - 9 lines]
|
| BJ

Reply to this Message

BJ - 28 May 2008 20:53 GMT

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

> It depends on what you mean with "review".
> The Tools>Formula Auditing commands (like Evaluate Formula) may already help you a lot.
[quoted text clipped - 13 lines]
> |
> | BJ

Reply to this Message

Niek Otten - 28 May 2008 21:38 GMT

Perhaps you mean Jan Karel Pieterse's RefTreeAnalyser:

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

Signature

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
[quoted text clipped - 23 lines]
| > |
| > | BJ

Reply to this Message