Copy Merged Cells to Single Cells ??
Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and paste these merged cells contents to other cells that are not merged but always get an error : "Can't change part of a merged cell". Isn't there a way to cut and paste where the merged cells contents are treated as a single cells contents? Certain SPECIAL PASTE features? |
Copy Merged Cells to Single Cells ??
Try Paste Special Then
Paste Values "Al Franz" wrote: Have seen other posts on this and seems odd their is no solution. Have a column of cells where each cell is a few merged cells. Want to copy and paste these merged cells contents to other cells that are not merged but always get an error : "Can't change part of a merged cell". Isn't there a way to cut and paste where the merged cells contents are treated as a single cells contents? Certain SPECIAL PASTE features? |
Copy Merged Cells to Single Cells ??
Maybe I'm confused, but I have only received this message if I am trying to
paste to a merged cell? In other words, when the destination contains a merged cell, and pasting would result in the merged cells being changed? Pasting a merged cell to another area does not generate an error. If you simply paste, it pastes as a merged range. If you paste special, and then paste values, it only pastes the value - in one cell - as it should? -- Hth Kassie Kasselman Change xxx to hotmail "Al Franz" wrote: Have seen other posts on this and seems odd their is no solution. Have a column of cells where each cell is a few merged cells. Want to copy and paste these merged cells contents to other cells that are not merged but always get an error : "Can't change part of a merged cell". Isn't there a way to cut and paste where the merged cells contents are treated as a single cells contents? Certain SPECIAL PASTE features? |
Copy Merged Cells to Single Cells ??
With VBA it is
Sub CopyMerged() 'A1, B1 & C1 are merged Range("A1").Copy Range("E1") End Sub Seems to work for me. Mike F "Al Franz" wrote in message ... Have seen other posts on this and seems odd their is no solution. Have a column of cells where each cell is a few merged cells. Want to copy and paste these merged cells contents to other cells that are not merged but always get an error : "Can't change part of a merged cell". Isn't there a way to cut and paste where the merged cells contents are treated as a single cells contents? Certain SPECIAL PASTE features? |
Copy Merged Cells to Single Cells ??
Get the error that "This operation requires the merged cells to be
identically sized." "Mike" wrote in message ... Try Paste Special Then Paste Values "Al Franz" wrote: Have seen other posts on this and seems odd their is no solution. Have a column of cells where each cell is a few merged cells. Want to copy and paste these merged cells contents to other cells that are not merged but always get an error : "Can't change part of a merged cell". Isn't there a way to cut and paste where the merged cells contents are treated as a single cells contents? Certain SPECIAL PASTE features? |
All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com