Copy Method of Worksheet Class Failed

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Ron,

I ran your code (Copy a sheet from each workbook into your workbook) and
still get the same error! It errors out on roughly the 34th sheet.
 
Strange

How big are the files in Size?

Is this also happen if you convert the sheets to values
(Use also the commented code )
 
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

Macro to copy sheets to another workbook fails after about 45 copi 3
Excel Move or Copy Stopped Working? 0
Copying a sheet fails 2
Copy Worksheets To New Workbook 2
copy method of worksheet class failed: trying to copy a hidden she 4
Copy method of worksheet class failed - help! 11
run time error 1004 2
potential bug in copy method 3

Back
Top