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?

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" <[email protected]> wrote in message news:[email protected]...
>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?
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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?