Copy / Paste Merged Cells

L

LPS

Using Excel 2000, is is possible to copy and paste a range
which has merged cells such that the pasted data displays
only values.

When using paste special and the "formula" option, merged
cells will paste into the destination without problems but
when using paste special with the "value" option, merged
cells will not paste.

Is there a way to do this easily and if so, what is it?

Thx.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste into merged cells 2
Sharing workbooks limitations - Merged Cells 12
copy formulas over merged cells 2
Pasting into merged cells 1
Copy value only 1
Count with merged cells 2
Merged cell paste NIGHTMARE 2
VBA set thick borders around non empty cells in range 0

Top