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
It sounds to me like the OP has merged cells in the columns
somewhere, but not necessarily on the series he wanted to
copy. By duplicated the needed series on an otherwise unused
worksheet eliminates any merge problems.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
