Frank, you can not call macros (subroutines) in a cell. You can call
functions you create.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"frank" wrote in message
...
I need to call a macro from an IF statment, when a
condition is met in a different cell. Do I place the IF
statement in a cell AND what code do I use to call the
macro from the IF statement.

Any ideas will help.
Thanks, Frank