I have a macro which copies worksheets. After about 20 successful copies out
of 30, I get the error "Copy method of worksheet failed", like Excel just ran
out of steam or memory.

Does anyone know of a solution to this - perhaps a way of clearing the
memory cache (if that's the issue)?

Daniel