Please be more specific; What is the code of your macro and of your function? Under what conditions is your macro executed? etc.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
|I have a function that i need to be volatile, but when i run a short
| macro that usually takes about 30 seconds with this function as
| volatile it takes a long time to run ( i have never bothered even
| letting it complete). I wanted to do boolean logic and an if then but
| this doesnt seem to work any ideas on how to have a function not
| recalculate when a macro is running but recalculate when it is not?