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?

have a look here where the problem is discussed

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

Mike

"mwam423" wrote:

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?

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