Are there any methods to speed up the execution of VBA code.
I assume that the algorithms used cannot be improved anymore.
Would it be possible for example to transfer the code to a VB project and compile it? Would that be (sometimes) useful? Would that bring further problems?
Other methods?
You could look at the VBA doc on the ScreenUpdating Property. Macros that alter the worksheet run much faster if you turn off display updating while the macro is running.
FrankBoston is the pen name for Andrew Garland, Lexington MA
have a look at
http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
One of the biggest mistakes that I see on the Forums is unnecessary Selecting or Activating of Ranges, Worksheets and Workbooks. This is rarely needed and slows code down.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks