vba courses london - Is there a way to speed up macros

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Is there a way to speed up macros

Priya has attended:
Excel VBA course

by - delegate Priya [2 posts] (2006 Dec 7 Thu, 15:01) Reply

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

RE: Is there a way to speed up macros

by - trainer Garry gold contributer [188 posts] (2006 Dec 7 Thu, 15:53) Reply

Speed up code and stop screen flickering:
type at the begin of the macros

Application.ScreenUpdating=False
'Your code here.

Application.ScreenUpdating=True

· How To Find A Good VB For Access Trainer
· Company Roles in Visual Basic Training
· Should You Send Managers To VBA Training?
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Introduction to Visual Basic for Applications

Vba tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips