Copy/Paste error
Hi,
I am trying to simply copy cells C3:C33 (which are merged cells C,D,E) from sheet1 into column C (which is a singular cell) into sheet 2 So I select Cells C3:C33 from sheet1, goto sheet 2 and paste special/values into cell C1...I get this error "This operation requires the merged cells to be identically sized" is there anyway around this, using a formual or VB code ?? Thanks inadvance |
Copy/Paste error
"Anthony" wrote:
Hi, I am trying to simply copy cells C3:C33 (which are merged cells C,D,E) from sheet1 into column C (which is a singular cell) into sheet 2 So I select Cells C3:C33 from sheet1, goto sheet 2 and paste special/values into cell C1...I get this error "This operation requires the merged cells to be identically sized" is there anyway around this, using a formual or VB code ?? Thanks inadvance In sheet 2 cell C1: =Sheet1!C3 And drag down Then copy the cells and paste them into the same spot as values. |
Copy/Paste error
Thank you - worked well !
"~L" wrote: "Anthony" wrote: Hi, I am trying to simply copy cells C3:C33 (which are merged cells C,D,E) from sheet1 into column C (which is a singular cell) into sheet 2 So I select Cells C3:C33 from sheet1, goto sheet 2 and paste special/values into cell C1...I get this error "This operation requires the merged cells to be identically sized" is there anyway around this, using a formual or VB code ?? Thanks inadvance In sheet 2 cell C1: =Sheet1!C3 And drag down Then copy the cells and paste them into the same spot as values. |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com