application.volatile

[mwam423]

greetings, i have a UDF which, ideally, only needs to be application.volatile
at certain times. is there some code i can use to turn application.volatile
on and off for a UDF?

 

[Mike H]

have a look here where the problem is discussed

http://www.decisionmodels.com/calcsecretsj.htm

Mike

 

[mwam423]

thanks mike, this is really informative. appreciate the quick response!