I have a macro that copies a template sheet to make new
ones.

It works fine, but after about 17 copied sheets, I get
the message "Copy Sheet method failed" or something like
that. I save, close Excel, and then begin the macro
again from where it got to. It goes for another 17, then
debugs again.

Is there some memory cache issue here, and if so, is
there a way of clearing it without closing Excel?

Thanks in advance
Daniel