Copy Method of Worksheet Class Failed

[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.

 

[Ron de Bruin]

Strange

How big are the files in Size?

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