Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
RE :Copy method of Worksheet class failed? | Excel Programming |