Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Abhinav Manoj (AbhinavM8986)
Flextronics

Flextronics
IN
AbhinavM8986 Member since 2017 38 posts
Flextronics
Posted: Dec 20, 2017
Last activity: Dec 28, 2017
Posted: 20 Dec 2017 23:04 EST
Last activity: 28 Dec 2017 1:11 EST
Closed

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?

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 22 Dec 2017 11:05 EST
Asvinth Saravanan (Asvinth.S)
Flex Technology Inc
RPA Developer
Flex Technology Inc
IN

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!

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice