Can't paste as merge cells aren't identical
 

Running a macro that copies and paste special from one spreadsheet to another
and I get an error "operation requires merged cell's to be identically sized"
but my cells aren't merged!

Here's my code:
Range("g3").Copy
Workbooks(file).Activate
Worksheets("D.3. PD - ASLD").Activate
Range("e10").Select
Selection.PasteSpecial Paste:=xlPasteValues

The thing is that I have used almost identical code to copy the cells from
the "copy from" spreadsheet into an identical sheet as the "copy into" sheet
and it worked fine.

Maybe I'm being foolish, but am sure that neither cell is merged.

Any thoughts?

Can't paste as merge cells aren't identical
 

Please ignore - error in the code further up.



"Muttley" wrote:

Running a macro that copies and paste special from one spreadsheet to another
and I get an error "operation requires merged cell's to be identically sized"
but my cells aren't merged!

Here's my code:
Range("g3").Copy
Workbooks(file).Activate
Worksheets("D.3. PD - ASLD").Activate
Range("e10").Select
Selection.PasteSpecial Paste:=xlPasteValues

The thing is that I have used almost identical code to copy the cells from
the "copy from" spreadsheet into an identical sheet as the "copy into" sheet
and it worked fine.

Maybe I'm being foolish, but am sure that neither cell is merged.

Any thoughts?