View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Berend Botje[_5_] Berend Botje[_5_] is offline
external usenet poster
 
Posts: 1
Default Excel 2002 - Slow macros

This is indeed a bug. It has to do with the junk that is loaded into th
memory when starting the workbook. This amount can be huge, if th
workbook is old and is used frequently.

Solution:
Copy and paste the entire workbook (sheet by sheet) to anothe
workbook. Just copy the values and the VBA scripts, DO NOT cut an
paste or use the move/copy provided within excel

--
Message posted from http://www.ExcelForum.com