ok didn't think of that, well spotted. Still getting a debug after adjusting my code to:

 Workbooks("Reporting model - GM").Sheets(5).Range("C7:Z65534") = .Sheets(1).Range("A9:X65536").Values

What is strange is that i tried it with code in post #10 listing both copy and paste ranges as A1:X65536 to see if it would execute but no luck.