View Single Post
  #2   Report Post  
Alan
 
Posts: n/a
Default

To remove the formulas and leave the calculated values, highlight the range,
right click, 'Copy', right click again 'Paste Special', check 'Values', OK
Regards,
"Desperate" wrote in message
...
I have a large "extremely large" worksheet that I want the result of
formulas
in about 200 row to show as a static number even if the formulas is
edited.