Skip to main content
Contact a Moderator

Question

3
Replies
92
Views
 Abhinav Manoj (AbhinavM8986) Flextronics
Flextronics
IN
AbhinavM8986 Member since 2017 38 posts
Flextronics
Posted: December 20, 2017
Last activity: December 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?

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 21 Dec 2017 23:32 EST
Andrew Grondin (grona) PEGA GCS Solutions Engineer I
Pegasystems Inc.
US

You'd have to edit the macro itself to copy without formulas.
Posted: 4 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!

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