View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Autumn Dreams
 
Posts: n/a
Default Replace Function

When I use the Replace function to replace -06 with -07 (changing the year in
each formula) and click Replace All, a window comes up "Update Values -06"
and opens into My Documents. To get rid of it you have to click cancel for
each formula highlighted and that would entail 240 times. How do I get past
this?