Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy method of worksheet class failed - loop copying worksheets
Hi again, Here's another one I found documentation for online but still can' manage to fix. I am using a certain sheet as a template that gets copied and rename many times. After a while I get the following error Run-Time error '1004' : Copy method of worksheet class failed I read that this is related to an excel limitation/bug that causes thi and found some microsoft articles explaining that the file must b opened and closed as a workaround. What's the best way to workaround this bug? At most I will need to d like 25 worksheet copies in a session - This is the code that causes the problem. Worksheets(template(I)).Select Worksheets(template(I)).Cop after:=Worksheets(Application.Sheets.Count) Thanks so much for any help - My head is hurting from trying to fi this. Lui -- li ----------------------------------------------------------------------- lif's Profile: http://www.excelforum.com/member.php...fo&userid=3574 View this thread: http://www.excelforum.com/showthread.php?threadid=56682 |
Reply |
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 - help! | 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 |