Using Code Editor Slows execution speed
I have noticed lately that with some of my applications whenever I make a
change to code using the Code Editor the execution speed drops tremendously. If I save the very same changes, and then exit Excel altogether and then restart Excel, the speed of execution is normal. I have found one thread dealing with this issue at Subject: breakpoint affecting the run speed of a macro 12/1/2006. However, I do not see any response to that issue. Any ideas? Lon Sarnoff |
Using Code Editor Slows execution speed
You might take a look at the link below. This might offer you an explanation
and a fix. Another way is to save all your modules to text files, delete the modules, then paste the code back in. That's really all this codecleaner does. It just does it real quick. This version has a monitor that backs code changes at save, which I find myself using more and more the older I get, lol. Regards, Alan http://www.appspro.com/Utilities/CodeCleaner.htm "Lon Sarnoff" wrote in message ... I have noticed lately that with some of my applications whenever I make a change to code using the Code Editor the execution speed drops tremendously. If I save the very same changes, and then exit Excel altogether and then restart Excel, the speed of execution is normal. I have found one thread dealing with this issue at Subject: breakpoint affecting the run speed of a macro 12/1/2006. However, I do not see any response to that issue. Any ideas? Lon Sarnoff |
All times are GMT +1. The time now is 01:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com