I've tried deleting rows 1 by 1 in a new workbook and I
get the same result, basically it slows down after
deleting 20 rows 1 by 1


-----Original Message-----
THanks for the quick response

This has slightly improved and helps delete around 100
rows almost instantaneously, however, it then slows down
again, is there anything else I could do?


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

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


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

.

.