Copy Method of Worksheet Class Failed

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

Steph

Half of the files are 96kb, half are 5.4Mb. I did use the commented
out are of your code to eliminate the formulas. I also had that bid
of code in my original procedure. I'm baffled!


Strange

How big are the files in Size?

Is this also happen if you convert the sheets to values
(Use also the commented code )
 
Hi

If you start with a new workbook and copy the macro in it
do you get the same result then.
 
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

copy method of worksheet class failed: trying to copy a hidden she 4
Copy method of Worksheet class failed 1
Code works on sheet but not from code-to-sheet 2
Runtime error 1004: Select method of worksheet class failed 3
Copy method of Worksheet class failed 4
Copy method of worksheet class failed - help! 11
Add method of "Sheets" class fails 3
CopyPicture method of range class failed using RangeName 5

Back
Top