Error 1004 when selecting range from different sheet

Hi, Im quite new to excel and VBA but i somehow managed to churn out a program that automates the process of generating a summary.

what its supposed to do is generate a summary for each sheet and then generate and overall summary in the summary sheet.

this all works fine.. except when i try to merge similar cells in the main summary sheet it gives me a 1004 error. which i just cant understand.

Heres the code:

Please Login or Register  to view this content.

The section ive commented out is the section that creates the problem. The first Range function of that generates the 1004 error.

heres a test file

BOQ macro template.xlsm

the code is bound to the "Generate" button in the second sheet..

any help is greatly appreciated
thanks

The code looks unnecessarily complicated and could be trimmed, but need to understand the task at hand. I understand the summary bit, i.e. the summary from each sheet. but when you say

"generate a summary for each sheet"
How do you get(produce) a summary for each sheet?

hey man, yeah i agree the code looks unnecessarily complicated.. but well actually its my first proper vba program and im more worried about my deadline than elegance hehe
however the summary for each sheet part works.. it adds up similar parts in the part list and puts it in a table starting from Q5
and the main summary part works too.. where a copy of summary for each sheet is put in the "summary" sheet
the thing that doesnt work is the merge part. The final for loop. which should be really simple but im getting a 1004 error that doesnt make sense.
Thanks for replying

When I run your code, I did not get any error. I am also would not surprise if you get an error, as you have lots of "Select" on your code. If you do not select the correct item, it will lead to either error, or wrong output.