Karthik-Excelsior
Active Member
- Joined
- Mar 4, 2011
- Messages
- 313
Hi Excel gurus,
I've a huge template where I'm adding a couple macros - basically to copy-paste data across sheets. I realized that since the volume of data in the file is huge, even the macro is taking a lot of time to copy-paste.
But, when I try copy-pasting after disabling the 'Automatic Calculation' feature, it works in a second.
So, my question here is, is it a good idea to disable auto calc before executing this event & turning it on after?
Something like..
ThisWorkbook.Sheets("Summary").EnableCalculation = False
{code}
ThisWorkbook.Sheets("Summary").EnableCalculation = True
what are your thoughts here? Thanks!
I've a huge template where I'm adding a couple macros - basically to copy-paste data across sheets. I realized that since the volume of data in the file is huge, even the macro is taking a lot of time to copy-paste.
But, when I try copy-pasting after disabling the 'Automatic Calculation' feature, it works in a second.
So, my question here is, is it a good idea to disable auto calc before executing this event & turning it on after?
Something like..
ThisWorkbook.Sheets("Summary").EnableCalculation = False
{code}
ThisWorkbook.Sheets("Summary").EnableCalculation = True
what are your thoughts here? Thanks!