Copying Merged Cells

I have a macro that's trying to copy the contents of merged cells onto the end of a group of merged cells.

For example, imagine each box is a group of three cells merged together and '1' or '2' means it has a value.

Sheet 1:
[1][1][][][]
Sheet 2:
[2][2][][][]

When I run the macro, it should create this:

Sheet 1:
[1][1][2][2][]

Please Login or Register  to view this content.

In Excel 2007, it works fine, but in Excel 2003 it tells me the cells are not identical, but they are exactly identical because Sheet 2 is an exact copy of Sheet 1.

The solution I've found is just to unmerge the cells where I intend to paste, and then to paste over them, which returns the format.