It is a known issue. Give this a gander...

http://support.microsoft.com/default...b;en-us;210684
--
HTH...

Jim Thomlinson


"Daniel Bonallack" wrote:

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