+ Reply to Thread
Results 1 to 5 of 5

runtime error 1004 paste method of worksheet class failed

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    2

    runtime error 1004 paste method of worksheet class failed

    Very new to VBA and having trouble with a simple macro running in 2010 that copies and paste to another worksheet. Code as follows:

    Please Login or Register  to view this content.
    When I run CopyResults, the sheet is opened but I get a runtime error 1004 paste method of worksheet class failed, with the line 'ActiveSheet.Paste' highlighted.

    Does anyone know how I can solve this issue. Thanks
    Last edited by JBeaucaire; 06-11-2014 at 08:35 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: runtime error 1004 paste method of worksheet class failed

    Does this do any better?

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: runtime error 1004 paste method of worksheet class failed

    hi richard83,

    I guess the root of the problem the copied sheet block does not fit the available sheet space.
    Example: if you select A1 and run your code the copied selection would cause error while pasting in any cell except A1 because it is larger than available space of the sheet.

  4. #4
    Registered User
    Join Date
    06-11-2014
    Posts
    2

    Re: runtime error 1004 paste method of worksheet class failed

    JBeaucaire that doesnt seem to work. Thanks

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

    Re: runtime error 1004 paste method of worksheet class failed

    What range of data are you trying to copy?
    If posting code please use code tags, see here.

+ 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. Replies: 1
    Last Post: 02-26-2014, 09:32 PM
  2. Help: Runtime Error 1004 Paste Method of Worksheet Class Failed
    By robertc93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 10:50 AM
  3. [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
  4. 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
  5. 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

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