Macro deleting formulas instead of copying values (Excel 2016)
I have a button on a sheet with the below macro assigned, to copy the entire sheet with values from the parent sheet.
But when macro is run, the formulas from the parent sheets are deleted and left with the values only. The copied sheet have the formulas copied instead.
The macro is as below
Application.CutCopyMode = False
I want the formulas in my parent sheet remained as it is and the newly created sheet should only have the values, not formulas.
Is there a way to fix the issue.
Your expert views much appreciated