View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Lanier Michael Lanier is offline
external usenet poster
 
Posts: 74
Default A macro for converting formulas to formula results only

I need a macro that will convert a cell's formula to reflect its
formula result only based on the following:

Range is A10:C200
Only when formula's result 0
Execute upon closing the file

Thanks for any help you can provide.

Michael