Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet copy method fails...
Hello.
I have a process that has a lot of data to process. So, I split it up so that it process each project separately. To do this, I have a template sheet that is being copied out to process the individual projects. After processing closet to half of them (I'm not sure yet if the fail point is consistent), the sheet.copy method fails. This time, it was on the 179th attempt at it. Does that sound like I'm running into a memory error? I debugged and just put a sheets(1).copy sheets(1) in there just to test for sure that it was the sheets.copy method failing. It is. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet copy method fails...
It is a known issue...
http://support.microsoft.com/default...b;en-us;210684 -- HTH... Jim Thomlinson "mark" wrote: Hello. I have a process that has a lot of data to process. So, I split it up so that it process each project separately. To do this, I have a template sheet that is being copied out to process the individual projects. After processing closet to half of them (I'm not sure yet if the fail point is consistent), the sheet.copy method fails. This time, it was on the 179th attempt at it. Does that sound like I'm running into a memory error? I debugged and just put a sheets(1).copy sheets(1) in there just to test for sure that it was the sheets.copy method failing. It is. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet copy method fails...
Thanks, Jim.
I was copying it out to a separate workbook, but, basically, it's the same thing. Thanks for pointing me to the article. Mark "Jim Thomlinson" wrote: It is a known issue... http://support.microsoft.com/default...b;en-us;210684 -- HTH... Jim Thomlinson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste method fails in VBA | Excel Programming | |||
Copy to another sheet fails | Excel Programming | |||
Chart location method fails using sheet name | Excel Programming | |||
Select method of Range fails | Excel Programming | |||
Copy method fails in IIS | Excel Programming |