Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing Large IF statements - Any tools?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing Large IF statements - Any tools?
If you enter edit mode for the cell you can hit Alt-Enter and break the
formula up so it is easier to read. I also add spaces to act as indents so it looks more like a structured VBA if statement. i.e. =if(a1="right", "Hooray", if(a1="wrong", "#@$%^^#$%@!!", "Oh Well")) "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing Large IF statements - Any tools?
smart indenter may help sort it out, too.
http://www.oaltd.co.uk/Indenter/Default.htm -- Gary "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing Large IF statements - Any tools?
and this print utility may also help, though it's not free, you can try it for
30 days http://submain.com/?nav=products.pcp -- Gary "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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing Large IF statements - Any tools?
<quote
I have some really large and complicated IF statements (formula type, not VBA) ... </quote -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... smart indenter may help sort it out, too. http://www.oaltd.co.uk/Indenter/Default.htm -- Gary "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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing Large IF statements - Any tools?
sorry must have missed that part.
knew we kept you around for something<g -- Gary "Bob Phillips" wrote in message ... <quote I have some really large and complicated IF statements (formula type, not VBA) ... </quote -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... smart indenter may help sort it out, too. http://www.oaltd.co.uk/Indenter/Default.htm -- Gary "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reviewing Large IF Statements - Any Tools available? | Excel Worksheet Functions | |||
Reviewing Tool Bar | Excel Discussion (Misc queries) | |||
Reviewing Toolbar | Excel Discussion (Misc queries) | |||
Using reviewing tools in macros | Excel Programming | |||
Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools | Excel Programming |