title: How to remove formulas from sheet but keep their calculated values
body: <p>Can you please let me know how I can remove all formulas from a sheet but keep the results of calculations in excel VBA?</p>
  
  <p>I have a sheet called map which has lots of calculation columns there now I would like to remove all of this formulas but still keep the result to save into a new sheet.</p>