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.