Results 1 to 12 of 12

Runtime error '1004': Paste special method of range class error.

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Calgary, Alberta
    MS-Off Ver
    2013 Home
    Posts
    7

    Smile Runtime error '1004': Paste special method of range class error.

    Trying to filter a few numbers from a larger group of numbers in one cell, copy them, then paste them in another cell. Error comes up as "Runtime error '1004': Paste special Method of Range class fail". When I go to "debug", it shows this:

    Sub Macro1()
    '
    ' Macro1 Macro
    ' averages
    '
    ' Keyboard Shortcut: Ctrl+m
    '
        Range("F4:F16").Select
        Selection.ClearContents
        ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1, Criteria1:=RGB(198, _
            239, 206), Operator:=xlFilterCellColor
        Range("A8:A239").Select
        Selection.Copy
        ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1
        Range("F4:F15").Select
        ActiveSheet.Paste
    End Sub


    How can I get my macro to cut and paste what I want without this error? The macro does EVERYTHING I asked of it, except paste. Thanks
    Attached Files Attached Files
    Last edited by alansidman; 10-30-2014 at 02:47 AM. Reason: To simplify document

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. runtime error 1004 paste method of worksheet class failed
    By richard83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2014, 10:32 AM
  2. Run time error: 1004 Paste special method of range class failed
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2014, 02:04 AM
  3. runtime error 1004 - paste method of worksheet class failed
    By fmxwannabe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2014, 09:32 PM
  4. [SOLVED] VBA Error: Runtime Error 1004: AutoFilter method of Range class failed
    By jl22stac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 07:27 PM
  5. [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

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