In general the advice is to avoid using merged cells. There is usually a
better solution.
--
David Biddulph

"David" wrote in message
...
How do I paste a workksheet that has merged cells & formulas into a new
worksheet to have just values and the same merged cells