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][]

Windows(filename).Activate----Sheet 2
Sheets(SheetSKUs).Range(Cells(2, 1), Cells(2, lastcolumn)).Copy----In this example, last column would give me 9, so that it copies 3 groups of 3 merged cells, which is the amount of open space in the first sheet
Windows(template).Activate----Sheet 1
Sheets(SheetSKUs).Select
Range(Cells(2, skuColumn), Cells(2, 15)).PasteSpecial xlPasteValues-----skuColumn would give me 7, which is the first column of an open cell
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.