I have code to copy a master tab, rename the tab based on data then
update several cells inside the new tab. By the end of the macro
there will be well over 100 new tabs in the workbook. The loop works
for the first 40 or so, then crashes with Run-Time Error 1004.

When I close the macro and attempt to copy a sheet it acts like it
did it, but no new tab is created. I am able to insert new
worksheet. When I save, close, reopen I can manually copy more tabs.

I found on the internet that Microsoft is telling me to do what I
found on my own as a work around, but there has to be a better way
than this bandaide. Save/close/reopen will take too much cycle time
for the user. I tried saving alone to no avail. It has to be closed
and reopened.

Anyone else have a better aproach than Microsoft?
http://support.microsoft.com/kb/210684