copy method of worksheet class failed

G

Guest

I have used a for loop to generate new worksheets by the following statments:

For i = 1 To InputCaseNum
Worksheets(EnvTemplate(i)).Copy after:=Worksheets
Next i

I have got the following error message if the number of new worksheets
generated exceeds 30:

Run-tim error '1004':
Copy method of Workshet class failed

How can I resolve this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy method of Worksheet class failed 1
Select method of Range Class failed 8
copy method failed 12
Run-time-error 1004 "ListIndex method of listbox class failed" 1
" Select method of range class failed" if sheet not on top 4
Worksheet Sharing VBA 3
Copy method of worksheet class failed - help! 11
CopyPicture method of range class failed using RangeName 5

Top