+ Reply to Thread
Results 1 to 8 of 8

paste.special is failing

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    paste.special is failing

    Hi,

    Im getting an error (1004) on the ActiveSheet.Paste line near the bottom of the code below. I've seen this plenty elsewhere but cant seem to correct it... Could anyone help?


    Please Login or Register  to view this content.
    Last edited by Barking_Mad; 03-05-2014 at 08:23 AM. Reason: SOLVED!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: paste.special is failing

    Does this work?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: paste.special is failing

    Hi Norie,

    The bottom part of code now reads:

    Please Login or Register  to view this content.
    However i'm getting an error: "Unable to get select property range of class" highlighting this line of code:
    Please Login or Register  to view this content.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: paste.special is failing

    Oops, remove .Select.

    Also, remove these lines of code.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: paste.special is failing

    Hi,

    That works fine once, but when i run it again I get another "PasteSpecial method of range class failed" error, with this line,

    Please Login or Register  to view this content.
    that's further up the code in my original post...

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: paste.special is failing

    You only mentioned ActiveSheet.Paste in the first post.

    Anyway, try this.
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: paste.special is failing

    haha sorry i did. that's because im an idiot who doesnt know what he's doing

    Thanks Norie, that works perfectly

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: paste.special is failing

    No problem.

    I actually didn't see the PasteSpecial at first, it was only when you pointed it out I found it.

+ 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. Trap Catch Differentiate Disable Paste Button from Paste Special Options
    By m3atball in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2013, 07:28 PM
  2. ActiveSheet.Paste failing(Runtime error '1004')
    By sanjeevap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 12:58 PM
  3. Replies: 1
    Last Post: 12-05-2012, 11:37 AM
  4. [SOLVED] how can I paste text using paste special, without clicking paste button?
    By Exxcel Noob in forum Excel General
    Replies: 6
    Last Post: 05-14-2012, 08:21 PM
  5. [SOLVED] characters / paste special-paste link / absolute/relative default
    By LWD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2005, 08:20 PM

Tags for this Thread

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