Brian Barker wrote:
<<SNIP>>Sorry, but I don't see how this addresses the problem: in
fact, I'm confident it doesn't. Any merged cells in the copied
material will retain their merged status in the temporary pasted
result, so whatever you copy back to the original target will be just
the same as the original copy. If you choose a different range to
copy back, you could equally have done that from the original source.
And anything already merged in the target range will still be merged,
of course.
Anyway, the questioner said none of her (his?) cells were merged, so
my guess was that the rogue merged cells were not in the source or
target ranges, but elsewhere in the rows or columns of the target that
would be affected when cells were moved down or right in the Paste
Special operation. Again, this problem would not be affected by
staging any material via another sheet.
Brian Barker
On new worksheet the formula form =Sheet1.A1 to cover the desired range
will have no merged cells, even if the range on
sheet1 does have merged cells.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
