run a macro in excel formula
 

Hi all

Is there a way i can get an excel formula to execute a macro if the
conditions are true. eg.

excel formula:

=if(c110,(macro),"-"


(macro) to be an autofilter function which I have written. I am
looking at automating the macro from the formula rather than someone
having to press the assigned button. If there is a simple way, any
help would be appreciated

cheers

Rabbi


--
rabbi
------------------------------------------------------------------------
rabbi's Profile: http://www.excelforum.com/member.php...o&userid=20178
View this thread: http://www.excelforum.com/showthread...hreadid=500517