I have a line that copies a sheet from one book to another. It works a
number of times in my macro then inexplicably stops working.

The line is:
ActiveSheet.Copy Before:=Workbooks(NewBookName).Sheets("XXX")

And I get the error: 1004
"Copy method of worksheet class failed"

It stops when I try to add the 54th sheet in a workbook - I don't know if
that number is significant.

There is no problem with the string: 'NewBookName' or the sheet named 'XXX'
(as I say the line works 52 times)

But suddenly I get an error

Anyone seen this before?

Thanks

M

There have been several similar postings about this condition. In most
cases, I believe the resolution was to make a loop where after so many
copies it would break and then resume. But I don't relly remember all the
details.


"Michelle" <(E-Mail Removed)> wrote in message
news:1583A1D3-8908-49D2-90AC-(E-Mail Removed)...
>I have a line that copies a sheet from one book to another. It works a
>number of times in my macro then inexplicably stops working.
>
> The line is:
> ActiveSheet.Copy Before:=Workbooks(NewBookName).Sheets("XXX")
>
> And I get the error: 1004
> "Copy method of worksheet class failed"
>
> It stops when I try to add the 54th sheet in a workbook - I don't know if
> that number is significant.
>
> There is no problem with the string: 'NewBookName' or the sheet named
> 'XXX' (as I say the line works 52 times)
>
> But suddenly I get an error
>
> Anyone seen this before?
>
> Thanks
>
> M

See
http://support.microsoft.com/kb/210684/en-us

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"JLGWhiz" <(E-Mail Removed)> wrote in message news:eY#(E-Mail Removed)...
> There have been several similar postings about this condition. In most
> cases, I believe the resolution was to make a loop where after so many
> copies it would break and then resume. But I don't relly remember all the
> details.
>
>
> "Michelle" <(E-Mail Removed)> wrote in message
> news:1583A1D3-8908-49D2-90AC-(E-Mail Removed)...
>>I have a line that copies a sheet from one book to another. It works a
>>number of times in my macro then inexplicably stops working.
>>
>> The line is:
>> ActiveSheet.Copy Before:=Workbooks(NewBookName).Sheets("XXX")
>>
>> And I get the error: 1004
>> "Copy method of worksheet class failed"
>>
>> It stops when I try to add the 54th sheet in a workbook - I don't know if
>> that number is significant.
>>
>> There is no problem with the string: 'NewBookName' or the sheet named
>> 'XXX' (as I say the line works 52 times)
>>
>> But suddenly I get an error
>>
>> Anyone seen this before?
>>
>> Thanks
>>
>> M
>
>