Worksheets.Copy meathod fails after calling number of times
Posted by Sam Spackman on March 29, 2001 1:01 PM
Has anyone ever run into this? I have code which copies a worksheet multiple times after another sheet in the same workbook (renaming it something new after the copy). After running this macro 6 times (and it copies the sheet 4 times per run) it crashes with a 1004 error and says copy method of worksheets failed. Indeed, I can't even copy a worksheet if I terminate the procedure and just go into Excel. Has anyone ever seen this?