Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding a macro within a formula
I would like to run a macro if the criteria within a "IF" function is TRUE
eg. IF(g12=0,"run macro") can this be accomplished withing the formula or do I have to create it in VBA? I'm not at all familiar with Visual Basic. I'm trying to hide selected rows when a given value is equal to zero. Is there an easy way to accomplish this? Thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding a macro within a formula
An easy way of hiding rows is to set up Autofilters - then you can
choose a criteria for which to hide the rows (e.g. select Custom from the pull-down, then Does Not Equal and 0 (zero) to display only the non-zero rows). Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding a macro within a formula
Works like a charm! - thanks for your help Pete!
"Pete_UK" wrote: An easy way of hiding rows is to set up Autofilters - then you can choose a criteria for which to hide the rows (e.g. select Custom from the pull-down, then Does Not Equal and 0 (zero) to display only the non-zero rows). Hope this helps. Pete |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding a macro within a formula
Thanks for feeding back.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving the formula "average" over one column in a macro | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Help on Macro or Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Fill Formula - Macro | Excel Discussion (Misc queries) |