speeding up a macro

[Brenda]

Is there any additional code or setting that I can use to
speed up a macro?

 

[John Wilson]

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

 

[losmac]

Use: Application.ScreenUpdating = False
After: Application.ScreenUpdating = True

 

[steve]

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.

 

[pfsardella]

These links have a collection of tips for optimizing code.

http://www.cpearson.com/excel/optimize.htm
http://www.microsoft.com/officedev/articles/Opg/013/013.htm

HTH
Paul