+ Reply to Thread
Results 1 to 2 of 2

Can't paste as merge cells aren't identical

  1. #1
    Muttley
    Guest

    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?

  2. #2
    Muttley
    Guest

    RE: 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?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1