Automation macro produce error when copy and paste

[Klam]

Basically this marco was to compile 2 reports into 1 and I have been using this for 3 - 4 months. But today my marco could not work and show this error

http://img138.imageshack.us/img138/1...sterrorza8.jpg

The problem was the structure of these 2 reports is the same as the rest of the reports that I have done and when I do debugging, I was able to generated the report

Is there a limit to copying the number of the rows or the size of the data in these rows. Right now the numbers of rows that are copy are 1121 and column A to Q

[davesexcel]

It's hard to see what is wrong,
Maybe show the code or upload a zipped copy of the workbook so that we may see what the problem is