Can't paste as merge cells aren't identical

G

Guest

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?
 

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