View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Find volatile cells

Thanks Peo.

VolatileFuncs seems to be a worksheet of miscellaneous functions
demonstrating which ones are always recalculated. How can I use it to help
me find all volatile cells on my worksheet?

"Peo Sjoblom" wrote:

You can download volatilefuncs from here

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



--


Regards,


Peo Sjoblom




"hmm" wrote in message
...
Is there a way to find or select cells containing a volatile formula? The
formula could be used explicitly in the cell, or may be substituted by a
name
whose definition contains a volatile function.