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?