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