View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hemang Dave Hemang Dave is offline
external usenet poster
 
Posts: 1
Default Reviewing Large IF statements - Any tools?

Hi BJ

you might wanna try the formula auditing toolbar in excel. It's in
Tools/Formula Auditing.

Alternatively, within Formula auditing Evaluate formula is very useful. it's
more like watch variable debugging tool in C++.

Cheers
-HD

"BJ" wrote:

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