NickHK wrote:

Damien,
If you are copying/pasting within the same WB, then you can get memory
problems after x iterations. This is due to something to do with the Names
in the WB and according to MS only solution is to save, then close/reopen
the WB.
Don't have the MSKB link handy, but you can Google.

Thanks Nick, I'll check it out.

I tried smaller chunks by cycling through the worksheets and copying only
the usedrange, and wb.usedrange = wb.usedrange.value but all that caused
the same error.