+ Reply to Thread
Results 1 to 4 of 4

Method "PasteSpecial" of object 'range' failed

  1. #1
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Method "PasteSpecial" of object 'range' failed

    Gents,

    I have a this error and I can't figure why it's happening. My VBA works for all users except one. It failed at section.pastespecial

    Please Login or Register  to view this content.
    Code tags added, sorry.
    Thanks!
    Last edited by igoodable; 01-06-2016 at 01:27 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: Method "PasteSpecial" of object 'range' failed

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Re: Method "PasteSpecial" of object 'range' failed

    Anyone? I can't replicate the issue on my any of my test machines. It's strange that I get an error only one one user.

  4. #4
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Method "PasteSpecial" of object 'range' failed

    Try:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] "Method 'Range' of object '_worksheet' failed" when a different sheet is active
    By CO# in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2014, 11:48 AM
  2. [SOLVED] Receiving a "Method 'Range' of object'_Global' failed" error
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-17-2013, 06:51 PM
  3. [SOLVED] "Pastespecial Method of Range Class Failed" while trying to Transpose
    By tenscourts in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2012, 02:37 PM
  4. "PasteSpecial method of Range class failed"
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2006, 06:45 AM
  5. [SOLVED] Excel-VBA: "1004 - Method 'Range' of object '_Global' failed"
    By THA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2005, 05:06 AM
  6. [SOLVED] "GoalSeek method of Range object failed" error message
    By Fixit_Steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2005, 04:06 PM
  7. Help: "PasteSpecial method of Range class failed"
    By PropKid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2005, 09:19 AM

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