+ Reply to Thread
Results 1 to 1 of 1

Help: Runtime Error 1004 Paste Method of Worksheet Class Failed

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Dub, Irl
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help: Runtime Error 1004 Paste Method of Worksheet Class Failed

    Hi,

    I am getting the above error when I run my macro. Could you please suggest a fix as I cannot seem to get around this error.

    Here is my code:

    Please Login or Register  to view this content.
    Thanks,

    Rob
    Last edited by robertc93; 02-11-2014 at 10:58 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Help: Runtime Error 1004 Paste Method of Worksheet Class Failed

    Rob,
    I have done the first for you. Since you have many, you could follow the example and change the rest. You may get an error on the second line if the auto-filter returns nothing.

    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] Runtime error 1004 paste method of worksheet class failed
    By Castillb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2013, 07:31 PM
  2. Help with Macro : runtime error 1004 paste method of worksheet class failed
    By aka189 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 05:32 PM
  3. runtime error 1004 paste method of worksheet class failed
    By wilsoj in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-26-2010, 05:58 PM
  4. Runtime error 1004 paste method of worksheet class failed
    By Sezai in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2008, 12:32 PM
  5. Runtime Error Paste Method of Worksheet class failed
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2006, 11:15 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