VBA chart-drawing excel macro CPU/Memory optimization
Posted on 2004-04-27
I'm not sure if this is the right place to ask...But here it is.
I have 200 columns and 40 rows long sheet in Excel and I have coded a Macro to plot charts of every column agains every other (to understand correlation between the data).
Now the problem is that while plotting, with ScreenUpdate=False, my CPU utilization shoots up to 100% ...plotting hundreds of those charts in new sheets (one per column under consideration)! ....and it takes FOREVER..to finish it........
Please let me know if you know of a trick or optimization to reduce my CPU and MEMORY utilization for such a macro!
Thanks (hope I explained it well!)