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" 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.

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.