copy last 3 columns to next with tile cell merged

[pmchris]

Hi,

I want to copy last 3 columns in a worksheet to next. The issue is the title for these 3 columns are merged. see attached. For example, I want to copy columns G, H and I to J, K and L. Can anyone help me produce this code? I tried to use the method "last cell or last column", but it does not work.

thank you

[jolivanes]

Get rid of the merged cells. Use Center Across Selection instead.

Please Login or Register  to view this content.

If you don't want to change it manually, use this.
Merged cells are known to give problems. Maybe not today but in the future more than likely.

Please Login or Register  to view this content.

[pmchris]

Wow, thanks a lot. The code works perfectly. Also, I learned something new (Center Across Selection).

[jolivanes]

Good to hear that all is well.
Good Luck