+ Reply to Thread
Results 1 to 4 of 4

Advanced Filtering -Runtime Error 1004. Cannot figure out why will not work.

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Exclamation Advanced Filtering -Runtime Error 1004. Cannot figure out why will not work.

    I am trying to sort Column O from sheet "DM" by the user entered criteria in Column A from Sheet "Project".
    O would look like:
    A254.920
    B692.R3U
    GN99.900

    A would look like:
    *A254*
    *G*

    The user can enter as many criteria in A as they would like.

    Please Login or Register  to view this content.
    I get "Run-time error 1004: Application-Defined or Object-Defined error"

    I do not see where I went wrong here. Can anybody give me some help?

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Advanced Filtering -Runtime Error 1004. Cannot figure out why will not work.

    Hi, thelisa,

    I´m missing the header for working with Advanced Filter.

    Try this:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Advanced Filtering -Runtime Error 1004. Cannot figure out why will not work.

    your criteria range is missing a piece
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    03-27-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Advanced Filtering -Runtime Error 1004. Cannot figure out why will not work.

    Thank you so much, JosephP!

+ 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. Simple Activesheet.paste will not work (Runtime 1004 error)
    By yjung15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 02:42 PM
  2. Runtime Error 481 invalid figure when PNG
    By Stingone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2013, 03:57 PM
  3. run-time error '1004' - advanced filtering not working
    By scubadiver007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 05:49 PM
  4. [SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004
    By charizzardd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 03:34 PM
  5. Excel 2003 Macro Error - Runtime error 1004
    By Cow in forum Excel General
    Replies: 2
    Last Post: 06-07-2005, 09:05 AM

Tags for this Thread

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