I have code that automatically creates excel graphs. After a few months, the amount of graphs that it needed to create grew from 10 to 50 and the execution time significantly slowed down.
I realized that if you minimize the application while it is running, it speeds up dramatically. Alternatively, you could use this vba function: Application.ScreenUpdating = False, which will stop updating the screen as the code is being executed.
Just remember to turn it back on at the end of your code: Application.ScreenUpdating = True
Sunday, January 16, 2005
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment