Copy Method of Worksheet Class Failed

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 )
 
R

Ron de Bruin

Hi

If you start with a new workbook and copy the macro in it
do you get the same result then.
 
Top