View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default keep cell value when another cell value changes

To retain / freeze the values returned by formulas,
do an "in-place": Copy Paste special Check "Values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"EE" wrote:
Hi I am trying to keep the cell value when another cell value within the
formula change.
Please help me

Thanks