Can you please let me know how I can remove all formulas from a sheet but keep the results of calculations in excel VBA?
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.