+ Reply to Thread
Results 1 to 2 of 2

Runtime error 1004 paste method of worksheet class failed

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    21

    Runtime error 1004 paste method of worksheet class failed

    Hi,

    I recorded a Macro and now trying to run but I'm getting the following error messgage

    "Runtime error 1004 paste method of worksheet class failed"

    Would this be caused by me copying and pasting data from another spreadsheet to the spreadsheet I am recording a macro on? When I select 'debug" the following text is highlighted yellow.

    ActiveSheet.Paste

    The error is occuring around this coding:

    HTML Code: 
    I'm new to this and appreciate any help.
    Last edited by Castillb; 05-02-2013 at 06:48 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Runtime error 1004 paste method of worksheet class failed

    Can you show the entire copy/paste code?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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