Posted to microsoft.public.excel.worksheet.functions

rjhutch

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
moving the formula "average" over one column in a macro	drumstu	Excel Worksheet Functions	1	August 23rd 05 08:01 PM
Formula for current month minus one = Quarter number in a macro.	Pank	Excel Discussion (Misc queries)	11	June 22nd 05 02:47 PM
Help on Macro or Formula	Nigel	Excel Discussion (Misc queries)	2	June 13th 05 01:27 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Fill Formula - Macro	Cathy U	Excel Discussion (Misc queries)	2	February 22nd 05 04:48 PM

All times are GMT +1. The time now is 08:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us