Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
|
|
|
The UK's most regular Training information: See also: |
|
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. |
Macros
Resolved · Low Priority · Version 2007
Reply Fri 7 Oct 2011, 13:49Delegate Christopher said...
Christopher has attended:
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced course
Macros
How do you know what part to remove in a macro to make it run faster?
For upcoming training course dates see: Pricing & availability
RE: Macros
Hi Christopher, thanks for your query. It's a bit of an art, I'm afraid. The macro won't run much faster by removing lines of code, unless those lines are taking a long time to process your information. The real way to significantly soup up the speed of your macros would be to code them from scratch in VBA, using loops and variables, rather than the script the macro recorder generates.
Hope this helps,
Anthony
Mon 17 Oct 2011: Automatically marked as resolved.
|