How about a macro that would go down column B in the source sheet looking for
mergers? It would create equivalent mergers in the destination sheet before
doing the paste?


Check back tomorrow.


--
Gary's Student
gsnu200709


"Gordon" wrote:

Thats my point...

I highlight column B in sheet 1 and then go to column B in sheet 2 and
paste. because column B is merged with CDEF&G the question is pasted into
thise cilumns too, even though the cell was merged. Pasting demerges and
places the question in 6 cells horizontally!

"merjet" wrote:

If Sheet2_Col_C is "just text", then how does copying from
Sheet1_Col_B to Sheet2_Col_B affect Sheet2_Col_C? At least that's the
way I read your #1. I can understand Col_C being affected if it has a
formula, but not if it "just text."

Hth,
Merjet