Infidel Rob
New Member
- Joined
- Apr 26, 2010
- Messages
- 22
I am trying to speed up one of my macros. The macro in question fills an array with data from the "Data" workbook, and then dumps it into a sheet in the "Charts" workbook. Loading the data takes a second or two, dumping it takes more than 90! (dumping it into a blank workbook also takes just a second or two.)
Having encountered something similar with formulas before, I have used Application.Calculation to turn off calculations (manual) prior to the loops that dump the array, and then turn it back on (automatic) after the dump, but this has not had the effect I expected.
The only thing I can think of is that this data feeds the various charts that exist in the "Charts" workbook (surprise!) and that they keep updating themselves as I dump the array. And that this updating isn't considered calculation as described above.
Is there another means of keeping the charts from updating until after the array has finished filling in the source data? Or do I just have to get used to a longer run time than I would like?
Thanks for any help you can provide.
Rob
Having encountered something similar with formulas before, I have used Application.Calculation to turn off calculations (manual) prior to the loops that dump the array, and then turn it back on (automatic) after the dump, but this has not had the effect I expected.
The only thing I can think of is that this data feeds the various charts that exist in the "Charts" workbook (surprise!) and that they keep updating themselves as I dump the array. And that this updating isn't considered calculation as described above.
Is there another means of keeping the charts from updating until after the array has finished filling in the source data? Or do I just have to get used to a longer run time than I would like?
Thanks for any help you can provide.
Rob