View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rjhutch
 
Posts: n/a
Default 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