Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Processing Speed
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Processing Speed
Resolved · Low Priority · Version 2007
Reply Wed 13 May 2009, 12:38Delegate Igor said...
Igor has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Processing Speed
Macros I develop on my computer are generally very slow on other machines that my colleagues use. I was wondering whether there is best practice to minimize the chance on the file crashing on slower computers, apart from choosing correct variable types so they do not take unnecessary space.
Thank you.
For upcoming training course dates see: Pricing & availability
RE: Processing Speed
Hi Igor
Thank you for your question
Macro speed is determined by a combination of PC memory, processor speed and the amount of data that is being manipulated. Operations can be speeded up by:
1. Switching screen updating off.
2. Avoid selecting cells in your code.(Note this is impossible when using recorded macros)
Also, when working with large amounts of data proceedings can be speeded up by processing the data in an array. This technique is covered on our Excel VBA advanced course.
Regards
Stephen
Wed 20 May 2009: Automatically marked as resolved.
|