Results 1 to 2 of 2

Runtime error 1004 paste method of worksheet class failed

Threaded View

Castillb Runtime error 1004 paste... 05-02-2013, 06:42 PM
davesexcel Re: Runtime error 1004 paste... 05-02-2013, 07:31 PM
  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.

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