Yes, merged cells are indeed a pain. Avoid them like the plague. Read the
archives of this group for countless reasons why.
--
David Biddulph

"ann" wrote in message
...
I have a merged cell in which I want to paste text from another cell.
Every
time I try get an error message saying that the cellsI have to unmerge the
merged cells first, paste, and them remerge. Is there any way to avoid
doing
this? It is a real pain.