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. Advertisements

  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. Advertisements

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. Smmiles

    Area Charts, area colors and series

    Smmiles, May 5, 2004, in forum: Excel Programming
    Replies:
    1
    Views:
    139
    Jon Peltier
    May 6, 2004
  2. bubz
    Replies:
    0
    Views:
    95
  3. ksp
    Replies:
    5
    Views:
    301
  4. Replies:
    5
    Views:
    136
  5. Marie J-son
    Replies:
    0
    Views:
    104
    Marie J-son
    Feb 8, 2006
  6. Michael Malinsky

    Graph Size not adjusting with Chart Area and Plot Area

    Michael Malinsky, Sep 7, 2006, in forum: Excel Programming
    Replies:
    2
    Views:
    158
    Michael Malinsky
    Sep 12, 2006
  7. Jarda Beran
    Replies:
    0
    Views:
    110
    Jarda Beran
    Feb 25, 2009
  8. Rick S.

    Create shape, name shape, add text to shape

    Rick S., Feb 26, 2010, in forum: Excel Programming
    Replies:
    2
    Views:
    459
    Herbert Seidenberg
    Feb 27, 2010
Loading...