+ Reply to Thread
Results 1 to 4 of 4

Excel paste special stops the sheet from working

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Stoke, England
    MS-Off Ver
    Ms 365
    Posts
    68

    Excel paste special stops the sheet from working

    Hi

    i have a strange problem if i copy anything and try to paste it using paste or paste special it will paste but then the sheet stops working not allowing me to cllick anything on iy until i press ctrl z the paste action dissapears and then i can use the sheet again however if i copy ang do ctrl v it pastes no problem and the sheet is fine

    Any ideas

    Thanks

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel paste special stops the sheet from working

    Can you post your code?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-11-2012
    Location
    Stoke, England
    MS-Off Ver
    Ms 365
    Posts
    68

    Re: Excel paste special stops the sheet from working

    Quote Originally Posted by xladept View Post
    Can you post your code?
    This is the only macro on the sheet

    Thanks

    Please Login or Register  to view this content.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel paste special stops the sheet from working

    Here's how I would write the first one:

    Please Login or Register  to view this content.
    Last edited by xladept; 01-08-2013 at 10:37 PM.

+ 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