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

ResolvedVersion Standard

Thu 7 Dec 2006, 15:01 Delegate 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:53 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

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

Is there a way to speed up macros

RE: Is there a way to speed up macros

VBA articles

VBA tip:

Count the Rows and Columns in a Selection