speeding up a macro
 

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

speeding up a macro
 

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 wrote:

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

speeding up a macro
 

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



Uzytkownik "Brenda" napisal w wiadomosci
...
Is there any additional code or setting that I can use to
speed up a macro?

speeding up a macro
 

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.

--
sb
"Brenda" wrote in message
...
Is there any additional code or setting that I can use to
speed up a macro?

speeding up a macro
 

These links have a collection of tips for optimizing code.

http://www.cpearson.com/excel/optimize.htm
http://www.microsoft.com/officedev/a...pg/013/013.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Wed, 20 Aug 2003 12:13:49 -0700, "Brenda"
wrote:

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