Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy sheet cells into differnt workbook/sheet, How? | Excel Discussion (Misc queries) | |||
Copy rows from multiple workbook into a different workbook (sheet) | Excel Programming | |||
automatic copy and paste from sheet to sheet in a workbook | Excel Programming | |||
Copy sheet from one workbook to another workbook problem | Excel Programming |