merge cells using vba

[UPA]

Hi excel guru,

I want to merge cells using vba.The below code working fine for product more than one but when there is only one product then below macro is not working.

Please find the attached sample file.

Please help me to solve this issue.

Regards

Upa

Please Login or Register  to view this content.

[abduljaleel.mca]

Attached sample file doesn't have complete information.
Please attach a sample file with multiple products in one sheet and its expected output in it. Also, another sheet with one product and expected result in it.

[UPA]

Hi abduljaleel.mca,

Thanks for the reply!

Please find the attached

Sheet1 having one product and sheet2 having multiple products.

Actually if in sheet1 having one product then i do not want to merge total price. if in sheet1 having multiple product then total price should merge.

regards

[abduljaleel.mca]

Made small changes in your code. Try this.

Please Login or Register  to view this content.

[UPA]

abduljaleel.mca, that is exactly what I am looking for. Works a treat. Thank you!

regards,

Upa

[abduljaleel.mca]

I'm glad that I was able to help you.