claudehenri
Technical User
Hi
I am copying a worksheet may time over into the same workbook. Once I reach 59 sheets (total) i get an error
Run-time error '1004':
Copy method of worksheet failed
the line of code i am using is
Worksheets("Boom").Copy After:=Worksheets(AfterSht)
"boom" is the sheet i have already copied 39 times
and AfterSht is the name of the last sheet that i copied.
don't know why this is happening. any ideas anyone?
I have had this occur before on occasion, with fewer sheets, and have been able to continue after having restarted xl. But even if restart the computer this still occurs.
Claude-Henri
I am copying a worksheet may time over into the same workbook. Once I reach 59 sheets (total) i get an error
Run-time error '1004':
Copy method of worksheet failed
the line of code i am using is
Worksheets("Boom").Copy After:=Worksheets(AfterSht)
"boom" is the sheet i have already copied 39 times
and AfterSht is the name of the last sheet that i copied.
don't know why this is happening. any ideas anyone?
I have had this occur before on occasion, with fewer sheets, and have been able to continue after having restarted xl. But even if restart the computer this still occurs.
Claude-Henri