+ Reply to Thread
Results 1 to 5 of 5

Run time error: 1004 Paste special method of range class failed

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    64

    Run time error: 1004 Paste special method of range class failed

    Hi

    I get this error when i copy columns from one workbook to another



    Please Login or Register  to view this content.
    I get this error when i paste in D2... Any suggestions please

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Run time error: 1004 Paste special method of range class failed

    hi, note that you are using
    Please Login or Register  to view this content.
    construct, but in fact you don't have dot in front of respective range. so whatever you do, you do it in the active workbook.
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Registered User
    Join Date
    07-31-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Run time error: 1004 Paste special method of range class failed

    Hi,

    Wen i put a .(dot) I get compliation error
    Please Login or Register  to view this content.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Run time error: 1004 Paste special method of range class failed

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Run time error: 1004 Paste special method of range class failed

    Thanks, TMS.

    @ amethystfeb: Look at TMS code. It can be written also:
    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. Getting Run-Time error '1004': Paste method of Worksheet class failed
    By randomguy1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2013, 10:47 PM
  2. [SOLVED] Run-time error 1004 paste method of worksheet class failed
    By Castillb in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-12-2013, 02:24 PM
  3. Help with a Macro-Paste method of worksheet class failed run time error 1004
    By mcneill_garr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2011, 03:10 PM
  4. Run-time error '1004': Paste method of Worksheet class failed
    By shafto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2009, 07:49 PM
  5. [SOLVED] Error:Paste Special method of range class failed
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2005, 05:50 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