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

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

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/