At 10:05 20/11/2008 -0800, JOE Conner wrote:
Kludge Work around: copy the cells to an empty worksheet, then copy from the worksheet. There will be no merged cells to contend with.
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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
