Data on the clipboard is not the same size and shape as the selected area..

Discussion in 'Excel Programming' started by Darin Kramer, Apr 15, 2005.

  1. Darin Kramer

    Darin Kramer Guest

    Hi guys,

    I get the following erro message "Data on the clipboard is not the same
    size and shape as the selected area.." when copying and pasting one row
    over an identical row. Both rows go from columns A to IV. Both should be
    identical - Have merged cells and hidden columns in both.

    the second part of the error message is "Do you want to paste
    anyway...?" when I say yes it pastes BUT the headers that where
    previously merged are now unmerged?

    How can I fix....?

    Thanks

    D

    *** Sent via Developersdex http://www.developersdex.com ***
     
    Darin Kramer, Apr 15, 2005
    #1
    1. Advertising

  2. Darin Kramer

    Tom Ogilvy Guest

    remerge the cells with your code.

    In earlier versions of excel, this will just raise an error - in case you
    were making some application you will distribute.
    --
    Regards,
    Tom Ogilvy

    "Darin Kramer" <> wrote in message
    news:...
    >
    >
    > Hi guys,
    >
    > I get the following erro message "Data on the clipboard is not the same
    > size and shape as the selected area.." when copying and pasting one row
    > over an identical row. Both rows go from columns A to IV. Both should be
    > identical - Have merged cells and hidden columns in both.
    >
    > the second part of the error message is "Do you want to paste
    > anyway...?" when I say yes it pastes BUT the headers that where
    > previously merged are now unmerged?
    >
    > How can I fix....?
    >
    > Thanks
    >
    > D
    >
    > *** Sent via Developersdex http://www.developersdex.com ***
     
    Tom Ogilvy, Apr 16, 2005
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jens Hoerburger
    Replies:
    0
    Views:
    263
    Jens Hoerburger
    Aug 24, 2006
  2. Janis
    Replies:
    1
    Views:
    61
    Jim Thomlinson
    Sep 7, 2007
  3. Lucky Bob
    Replies:
    3
    Views:
    204
    JuneTheSecond
    Sep 11, 2007
  4. Philip
    Replies:
    2
    Views:
    168
    Jay Freedman
    Sep 5, 2004
  5. Philip
    Replies:
    1
    Views:
    138
    Jay Freedman
    Sep 14, 2004
Loading...

Share This Page