Thread: copy method of worksheet class failed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Mak Dennis Mak is offline
external usenet poster
  
Posts: 1
Default copy method of worksheet class failed
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?
Reply With QuoteReply With Quote