Question
3
Replies
73
Views
Flextronics
Posted: December 20, 2017
Last activity: December 28, 2017
Disable Formulas in Excel Sheet
Hello guys
We have a case where we need to copy sheets from one workbook to another using macros but we have formulas in the worksheets and its taking a lot of time to copy. When we manually run the macro we can disable the formulas and enable it after copying .But through automation is there a way to do the same?
Posted: 2 years ago
Posted: 2 years ago
Hi Abhinav,
Before copying the worksheets, please use the below code in your macro:
********
Cells.select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
********
Thanks!
Posted: 2 years ago
Hey Thanks Asvinth.
You'd have to edit the macro itself to copy without formulas.