Thanks, but this is really impractical as the occurrence of merged cells is random and I'm copying large ranges of cells of which each possible range of merged cells is just a part. In the destination sheet everything has to come back together in exactly the right position. This would be a programming nightmare. Surely there is a way?...???

"RPIJG " wrote:

From what I know about in the programming, which isn't a ton, I believe
you have to label all parts of a merged cell for example instead of
just say B2 which is the upper most left cell of the merged cell, it
would be B2:E5 which would be all cells in the merged cell and not just
one cell. That may be the problem.


---
Message posted from http://www.ExcelForum.com/