Pasting merged cells ??

  • Thread starter Thread starter Ross Bennett
  • Start date Start date
R

Ross Bennett

I have 2 identical worksheets with merged cells in each and am trying to
copy & paste values only from one to the other. How can I do this without
removing all the merging from both sheets ???
 
Ross

If copying a merged area to an identically-sized merged area you should have
no problem.

Otherwise........lotsa problems unless you un-merge.

Merged cells are the spawn of SATAN!!!

Gord Dibben Excel MVP
 
Gord speaks the truth. Listen to him. You should never use the Merge Cells
feature. Ever. It comes with a lot of baggage, most of it bad. HTH
Otto
 
Back
Top