I am trying to copy data from one spreadsheet into another using VBA.
When I get to this line 
Selection.PasteSpecial xlPasteFormats
I get an error message saying "Too many different cell formats".
Selection.PasteSpecial xlPasteValues works fine but I need the formatting too.

I tried copying and pasting manually and this does not work at all.

I'm stuck