speeding up a macro

  • Thread starter Thread starter Brenda
  • Start date Start date
Brenda,

It all depends...
You could post the macro here and someone would surely
take a look at it.

Some hints on speeding things up.....
Application.ScreenUpdating = False
at the beginning of your code
and
Application.ScreenUpdating = True
at the end of your code is one of the simplest methods to
spped things up. (If you can see your screen bouncing around
to different places while the code is running, this is sure to help).

Try the above and if it doesn't help, post back with the code
you're trying to optimize.

John
 
Brenda,

Get rid of select (big performance hit)
Range("A1").Select
Selection.Value = 5
can be
Range("A1").Value = 5

If there is a lot of calculation
set calculation to manual at the beginning
and reset it to auto at the end.
 
Back
Top