Thread: Force UDF to re-evaluate
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Adrian C[_2_] Adrian C[_2_] is offline
external usenet poster
  
Posts: 21
Default Force UDF to re-evaluate
Adrian C wrote:
Andrew Wiles wrote:

Is there any way to flag all udf's for re-evaluation?

Yes. Put "Application.Volatile" at the start of the UDF.


Oh, and then do Application.CalculateFull ...

--
Adrian C
Reply With QuoteReply With Quote