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 VBA Training and help » vba courses london - Is there a way to speed up macros
vba courses london - Is there a way to speed up macros
Resolved · Low Priority · Version Standard
Thu 7 Dec 2006, 15:01Delegate Priya said...
Priya has attended:
Excel VBA Intro Intermediate course
Is there a way to speed up macros
I have macro that takes about 4-5 minutes to run and I wanted to find out if there is a way to speed this process up. Is this an excel problem or a hardware problem
Thu 7 Dec 2006, 15:53Trainer Garry said...
RE: Is there a way to speed up macros
Speed up code and stop screen flickering:
type at the begin of the macros
Application.ScreenUpdating=False
'Your code here.
Application.ScreenUpdating=True
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. |
VBA tip:Add A New Sheet at the end of the WorkbookTo add a new sheet at the end of the workbook you need to count the sheets in the workbook using: |
