Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 1004 Copy method of Worksheet class failed
I have a button on a worksheet that runs the CopySheet Macro:
Sub CopySheet() ActiveSheet.Copy after:=Sheets(ActiveSheet.Index) End Sub It works fine for the first 25-30 times I use it, then it starts giving me the following error: Run-time error '1004' Copy method of Worksheet class failed When I shutdown and restart excel, it works again for 25-30 times. Does anybody know why this would stop working? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 1004 Copy method of Worksheet class failed
Hi Paul
See this Kb for a workaround http://support.microsoft.com/default...84&Product=xlw -- Regards Ron de Bruin http://www.rondebruin.nl "Paul Hitchcock" wrote in message oups.com... I have a button on a worksheet that runs the CopySheet Macro: Sub CopySheet() ActiveSheet.Copy after:=Sheets(ActiveSheet.Index) End Sub It works fine for the first 25-30 times I use it, then it starts giving me the following error: Run-time error '1004' Copy method of Worksheet class failed When I shutdown and restart excel, it works again for 25-30 times. Does anybody know why this would stop working? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 1004 Copy method of Worksheet class failed
Paul,
Maybe something here... XL2000: Copying Worksheet Programmatically Causes Run-Time Error 1004 http://support.microsoft.com/default...b;en-us;210684 XL97: Copy Method of Sheets Object Causes Invalid Page Fault http://support.microsoft.com/default...b;en-us;177634 Regards, Jim Cone San Francisco, USA "Paul Hitchcock" wrote in message oups.com... I have a button on a worksheet that runs the CopySheet Macro: Sub CopySheet() ActiveSheet.Copy after:=Sheets(ActiveSheet.Index) End Sub It works fine for the first 25-30 times I use it, then it starts giving me the following error: Run-time error '1004' Copy method of Worksheet class failed When I shutdown and restart excel, it works again for 25-30 times. Does anybody know why this would stop working? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error 1004 Copy method of worksheet class failed | Excel Discussion (Misc queries) | |||
Run-Time Error 1004 Copy method of worksheet class failed | Excel Programming | |||
Run Time error 1004 Paste Method of Worksheet Class Failed | Excel Programming | |||
Run-time error '1004' PasteSpecial Method of Range Class Failed | Excel Programming | |||
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004 | Excel Programming |