Copy sheet in a workbook
 

Hi,

I have some problem with programmatically copy paste sheets within a workbook.

When I got in my program to the 50/55th instance, it suddenly write:
"Copy method of Worksheet Class failed!"

Then if I try to copy manually, it even does not work, only, if I copy the
sheet to a new workbook, and then go back and try again copy the original
sheet.

Can anybody help what can cause this problem?

Thanks

Copy sheet in a workbook
 

Please post your code.
Thanks,
Barb Reinhardt



"pontitt" wrote:

Hi,

I have some problem with programmatically copy paste sheets within a workbook.

When I got in my program to the 50/55th instance, it suddenly write:
"Copy method of Worksheet Class failed!"

Then if I try to copy manually, it even does not work, only, if I copy the
sheet to a new workbook, and then go back and try again copy the original
sheet.

Can anybody help what can cause this problem?

Thanks

Copy sheet in a workbook
 

Check out this link...

http://support.microsoft.com/default...84&Product=xlw
--
HTH...

Jim Thomlinson


"pontitt" wrote:

Hi,

I have some problem with programmatically copy paste sheets within a workbook.

When I got in my program to the 50/55th instance, it suddenly write:
"Copy method of Worksheet Class failed!"

Then if I try to copy manually, it even does not work, only, if I copy the
sheet to a new workbook, and then go back and try again copy the original
sheet.

Can anybody help what can cause this problem?

Thanks

Copy sheet in a workbook
 

For i = 1 To 58
Sheets("Rep").Copy Befo=Sheets("Rep")

....

if this helps

"Barb Reinhardt" wrote:

Please post your code.
Thanks,
Barb Reinhardt



"pontitt" wrote:

Hi,

I have some problem with programmatically copy paste sheets within a workbook.

When I got in my program to the 50/55th instance, it suddenly write:
"Copy method of Worksheet Class failed!"

Then if I try to copy manually, it even does not work, only, if I copy the
sheet to a new workbook, and then go back and try again copy the original
sheet.

Can anybody help what can cause this problem?

Thanks