Copy/Paste error

A

Anthony

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
 
L

~L

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top