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.
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
