Has anybody solved this little puzzle then?
I have read a number of the threads all relating to my problem.....
Running a macro that is copying a Master Sheet then renaming that
sheet and repeating a number of times......and then erroring! The
master sheet contains a number of charts so is quite beefy to copy.
It tends to stop after 15 copies.

Is the answer to save and close after say 12 copies then
continue...does this work? or has anybody any other solutions? If you
have to save and close do you have to log out of windows to clear it's
memory out or can I just reopen and continue?

Any suggestions would be gratefully recieved.

Thanks All.