METHOD
So, logically, to keep the memory usage to a minimum, the process
should be :-

1. Open File
2. Delete rows as necessary.
3. Transfer remainder to main file (copy/paste is quicker than row by
row.)
4. Close File
5. Loop back to 1.

TIME SAVING
1. Application.Calculation = xlCalculationManual at the beginning. Back
to xlCalculationAutomatic at the end.
2. Limit the Find process to a single column instead of searching the
whole sheet.
3. I would try sorting the data first and doing a block row deletion.
4. Use Copy/Paste to transfer to the main file.


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