Maybe I'm not remembering correctly but I recall this is only a problem when
you do a paste special, values. If that's your problem maybe you can do a
paste special, formulas. Alternatively do a Value = Value (e.g.,
range("A1:A10").Value = range("B1:B10").Value. Alternatively remove the
merged cell, paste, reset merged cell.

--
Jim
"Mekinnik" wrote in message
...
| What would be the best way to copy data from one sheet to another where as
| the cells of the copy to sheet are merged and not the same size as the
copy
| from sheet. I have check other posts and they all say to not use merged
cells
| and they have to be the same size. Is there a way around this?