Copy/Paste error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Anthony said:
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
Click to expand...

In sheet 2 cell C1: =Sheet1!C3 And drag down

Then copy the cells and paste them into the same spot as values.
 
Back
Top