| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy method failed
I have a macro which copies worksheets. After about 20 successful copies out
of 30, I get the error "Copy method of worksheet failed", like Excel just ran out of steam or memory. Does anyone know of a solution to this - perhaps a way of clearing the memory cache (if that's the issue)? Daniel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy method failed
It is a known issue. Give this a gander...
http://support.microsoft.com/default...b;en-us;210684 -- HTH... Jim Thomlinson "Daniel Bonallack" wrote: I have a macro which copies worksheets. After about 20 successful copies out of 30, I get the error "Copy method of worksheet failed", like Excel just ran out of steam or memory. Does anyone know of a solution to this - perhaps a way of clearing the memory cache (if that's the issue)? Daniel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy method failed
THANKS!
"Jim Thomlinson" wrote: It is a known issue. Give this a gander... http://support.microsoft.com/default...b;en-us;210684 -- HTH... Jim Thomlinson "Daniel Bonallack" wrote: I have a macro which copies worksheets. After about 20 successful copies out of 30, I get the error "Copy method of worksheet failed", like Excel just ran out of steam or memory. Does anyone know of a solution to this - perhaps a way of clearing the memory cache (if that's the issue)? Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Method 'Copy' of object'_Worksheet failed | Excel Worksheet Functions | |||
| Copy method of chart 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 | |||
Linear Mode
