|
-
Jul 13th, 2011, 01:33 PM
#1
Thread Starter
Member
[RESOLVED] [Excel VBA] ScreenUpdating = False to speed up code
So, one of the first tricks I learned to speed up code was Application.ScreenUpdating = False. I used it on one of the first programs I was working on and it made the program 9 times as fast, with one line of code. That program was written very badly when I got it, and by the time I was finished with it, it ran 125 times as fast as the original. I then found a program that was written well and tried the same thing, but it wasn't noticeably faster. In my test runs, it was actually slower sometimes. This is a program that took a long time to run, half hour or so.
So, have you noticed that this doesn't help all that much with well written code?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|