98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Processing Speed
Processing Speed
Resolved · Low Priority · Version 2007
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.
Thu 14 May 2009, 08:54Trainer Stephen said...
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.
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. |
Excel tip:Adding up time greater than 24 hoursWhen you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours. |
