Thread: volatile
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Spencer.Sadkin@gmail.com is offline
external usenet poster
 
Posts: 42
Default volatile

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?