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
|