Special Paste

[David]

How do I paste a workksheet that has merged cells & formulas into a new
worksheet to have just values and the same merged cells

 

[David Biddulph]

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

 

[Gary''s Student]

Copy the worksheet and not the values.