+ Reply to Thread
Results 1 to 6 of 6

Excel VBA advanced filter criteria range does not work

  1. #1
    Registered User
    Join Date
    08-14-2017
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    2

    Question Excel VBA advanced filter criteria range does not work

    I am doing a project one code involves filtering a 500000*3 of cells with criteria range of about 60. Its filtered by date.

    But, the criteria range does not work, and it wont filter. When I change the criteria range to a smaller one sometime it might work.

    What might be the reason?

    Here is the code:

    SRange.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=FRange, Unique:=False

    I the criteria range is dynamic and random so I guess I have to stick with the advanced filter

    First time poster, any help is appreciated

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel VBA advanced filter criteria range does not work

    what is the criteria?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,302

    Re: Excel VBA advanced filter criteria range does not work

    code looks OK (although that is a fair bit of filtering).
    I got it to run on a couple of ranges that I set up for Srange and Frange (big like yours).
    You should upload a file so we can see it in use.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel VBA advanced filter criteria range does not work

    create the exact same setup
    500000x3 columns + 60 individual criteria
    works no problems....albeit a rather large file size (13mb)

  5. #5
    Registered User
    Join Date
    08-14-2017
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    2

    Re: Excel VBA advanced filter criteria range does not work

    Thanks for the kind help guys, its seems odd to me as well because it should work perfectly. Can anyone show me how to upload excel files so we can take a closer look of the issue?

    I go to the advanced reply but the attachment feature does not work (its a blank broken box).

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel VBA advanced filter criteria range does not work


+ 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. Advanced filter with function as criteria range?
    By dakke in forum Excel General
    Replies: 23
    Last Post: 06-10-2021, 04:48 PM
  2. [SOLVED] Advanced Filter Code : Criteria Range More Than 1 Row Breaks Filter
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2021, 04:30 PM
  3. Advanced Filter Criteria Range Help
    By JoeGio25 in forum Excel General
    Replies: 0
    Last Post: 10-23-2011, 07:34 PM
  4. Replies: 3
    Last Post: 06-26-2010, 02:43 PM
  5. Advanced Filter - Criteria Range Issue
    By EB78 in forum Excel General
    Replies: 0
    Last Post: 06-27-2008, 05:38 PM
  6. [SOLVED] Advanced filter and Criteria Range
    By gearoid in forum Excel General
    Replies: 2
    Last Post: 07-20-2005, 10:05 AM
  7. Wildcards in Advanced filter criteria don't work with Excel 2003
    By Inconceivable in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2005, 10:05 PM

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