You can make you macro a function and then use it in your formula. Be aware
that macros used in this fashion can only return a value to the cell
containing the function - they can not format cells, change values in cells
or otherwise alter the Excel environment.

--
Regards,
Tom Ogilvy

"davidhub" wrote in message
...
I need to define a formula to run a predefined macro as a result of a
logical
comparision. Please help.