+ Reply to Thread
Results 1 to 10 of 10

Run time error '1004': PasteSpecial method of Range class failed

  1. 03-14-2012, 09:03 PM #1
    BorisGRU
    BorisGRU is offline
    Registered User
    Join Date
    03-14-2012
    Location
    Philadelphia, PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Angry Run time error '1004': PasteSpecial method of Range class failed

    I have a script which has been working for years. All of sudden it has stopped working. The only thing which I think happened recently is that there was an update downloaded and applied to Excel. The symptoms are:
    - This statement throws and error: Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    - An attempt to do the same thing manually won't work
    -- Right click|Copy (NOTE: cell border does not change)
    -- Right click|Paste Special (Only allows pasting text)

    Is there some option in Excel which needs to be changed so that this works correctly again?

    Attempts to correct:
    - Exit Excel and start again (no help)
    - Exit Excel and start with a new sheet, type in some values and formulas (same problems)

    Any hints greatly appreciated.
    Last edited by BorisGRU; 03-22-2012 at 11:21 PM. Reason: See last message to redirect to better thread
    Reply With QuoteRegister To Reply
  2. 03-14-2012, 11:12 PM #2
    AlvaroSiza
    AlvaroSiza is offline
    Valued Forum Contributor AlvaroSiza's Avatar
    Join Date
    09-19-2007
    Location
    Staffordshire
    MS-Off Ver
    2007
    Posts
    591

    Re: Run time error '1004': PasteSpecial method of Range class failed

    Off the cuff it sounds like Application.CutCopyMode = False. I would be interested in seeing the results if you added:
    Please Login or Register  to view this content.
    Perhaps it was the Noid who should have avoided me...
    If you are satisfied with my solution click the small star icon on the left. Thanks
    1. Make a copy of your workbook and run the following code on your copy (just in case)
    2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
    3. Paste the code from above into the empty white space. Close the VBE.
    4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
    Reply With QuoteRegister To Reply
  3. 03-15-2012, 12:48 AM #3
    BorisGRU
    BorisGRU is offline
    Registered User
    Join Date
    03-14-2012
    Location
    Philadelphia, PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Run time error '1004': PasteSpecial method of Range class failed

    While what you suggested appears to make sense, it wound up not making a difference. I wonder if there is some more global location to set this. I can't even do what I would normally do manually, since the paste special function doesn't work at all. What really has me puzzled is that the borders of the cell do not change when I copy it to the clipboard. It is as if the clipboard doesn't recognize the data as an Excel cell.

    De minimis example:
    Please Login or Register  to view this content.
    Further correction attempts have included rebooting the computer.
    Reply With QuoteRegister To Reply
  4. 03-15-2012, 12:51 AM #4
    AlvaroSiza
    AlvaroSiza is offline
    Valued Forum Contributor AlvaroSiza's Avatar
    Join Date
    09-19-2007
    Location
    Staffordshire
    MS-Off Ver
    2007
    Posts
    591

    Re: Run time error '1004': PasteSpecial method of Range class failed

    Do you still have your cut/copy/paste icons within the Home tab of the ribbon?

    Additionally, have you 'repaired' office via the control panel? It feels like a global setting was altered during the last update. Repairing should fix it.
    Last edited by AlvaroSiza; 03-15-2012 at 12:55 AM.
    Reply With QuoteRegister To Reply
  5. 03-15-2012, 01:08 AM #5
    BorisGRU
    BorisGRU is offline
    Registered User
    Join Date
    03-14-2012
    Location
    Philadelphia, PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Run time error '1004': PasteSpecial method of Range class failed

    Yes, the ribbon is as it should be (at least I think so, use keyboard shortcuts mostly). I will try the 'repair' option after some sleep and report findings.
    Reply With QuoteRegister To Reply
  6. 03-15-2012, 09:35 PM #6
    BorisGRU
    BorisGRU is offline
    Registered User
    Join Date
    03-14-2012
    Location
    Philadelphia, PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Run time error '1004': PasteSpecial method of Range class failed

    The repair did not make a difference. Any suggestions?
    Reply With QuoteRegister To Reply
  7. 03-17-2012, 11:09 AM #7
    BorisGRU
    BorisGRU is offline
    Registered User
    Join Date
    03-14-2012
    Location
    Philadelphia, PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Run time error '1004': PasteSpecial method of Range class failed

    Additional checks done (to no avail):
    Made sure there is only one instance of excel running

    Copy does NOT change the outline of the selected range.

    The only option I get when I try to use paste special is what is shown in this dialog box.
    Untitled.jpg
    Reply With QuoteRegister To Reply
  8. 03-17-2012, 11:42 AM #8
    Alf
    Alf is offline
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,787

    Re: Run time error '1004': PasteSpecial method of Range class failed

    Perhaps this link could be of help?

    http://j-walk.com/ss/excel/usertips/tip076.htm

    Alf
    Reply With QuoteRegister To Reply
  9. 03-17-2012, 11:59 AM #9
    BorisGRU
    BorisGRU is offline
    Registered User
    Join Date
    03-14-2012
    Location
    Philadelphia, PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Run time error '1004': PasteSpecial method of Range class failed

    Found the problem is an interaction between browsers and Excel. See post2733718 for where I found it.

    Is anyone else experiencing this issue?

    What is the best way to open a new thread referring to the problem of Excel having odd interactions with web browsers, and then close this thread pointing to the new thread which is more descriptive of the problem?
    Last edited by BorisGRU; 03-17-2012 at 07:20 PM. Reason: Added question about closing thread and redirecting to new thread
    Reply With QuoteRegister To Reply
  10. 10-31-2014, 07:09 PM #10
    ubiquity
    ubiquity is offline
    Registered User
    Join Date
    10-26-2014
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    1

    Re: Run time error '1004': PasteSpecial method of Range class failed

    The issue occurs independently of any browsers and appears to have no long term resolution.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1