Copy sheet in a workbook

's Computer Specifications

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

's Computer Specifications

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
>

's Computer Specifications

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
>

's Computer Specifications

For i = 1 To 58
Sheets("Rep").Copy Before:=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
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Copy sheet cells into differnt workbook/sheet, How?	Shane Devenshire	Microsoft Excel Misc	1	2nd Jun 2009 11:16 PM
Copy sheet cells into differnt workbook/sheet, How?	IVLUTA	Microsoft Excel Misc	0	2nd Jun 2009 10:56 PM
Copy rows from multiple workbook into a different workbook (sheet)	Yossy	Microsoft Excel Programming	19	11th May 2008 12:34 AM
Copy Range to a New WorkBook + Name Sheet a cell Value + Name WorkBook another Celll Value	Corey	Microsoft Excel Programming	2	2nd Nov 2006 05:01 AM
copy a sheet to a sheet within another workbook - WITHOUT buttons from the first shee	equex	Microsoft Excel New Users	0	21st Feb 2006 02:02 PM