Copy sheet in a workbook

  • Thread starter Thread starter pontitt
  • Start date Start date
P

pontitt

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

....

if this helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying cells and formula from closed workbook to all sheets in open workbook 0
Copying a sheet fails 2
Copy and paste sheets to new workbook 14
Macro to copy sheets to another workbook fails after about 45 copi 3
Copy sheet from workbook in new instance of Excel 3
Copy sheets to New Workbook - Excel 2007 1
XL2007 .CodeName bug when copying sheet 4
Copying a value from one workbook to another 3

Back
Top