+ Reply to Thread
Results 1 to 3 of 3

Advanced filter that will use a variable lenght range

  1. 10-03-2013, 07:31 PM #1
    Sibrulottes
    Sibrulottes is offline
    Registered User
    Join Date
    10-03-2013
    Location
    Montréal
    MS-Off Ver
    Excel 2010
    Posts
    4

    Advanced filter that will use a variable lenght range

    Hi, so I have to do an advanced filter on the Sheet "Data", and my criteria will be on Sheet "filtre", range A1, to A ... however long will there be data.

    I could put to A500 to be safe, but advanced filters don't work on blanks, so filtering fails.

    I'm trying to twiddle with this code, but I can't seem to make it happen:
    Please Login or Register  to view this content.
    I'm halfway noob, so please bare with me if I'm doing something stupid in the code.

    Thank you!
    Last edited by Sibrulottes; 10-04-2013 at 08:35 AM.
    Reply With QuoteRegister To Reply
  2. 10-03-2013, 10:05 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,963

    Re: Advanced filter that will use a variable lenght range

    CriteriaRange:= FRange
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 10-04-2013, 08:35 AM #3
    Sibrulottes
    Sibrulottes is offline
    Registered User
    Join Date
    10-03-2013
    Location
    Montréal
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Advanced filter that will use a variable lenght range

    I also solved using a named range with an Offset and count formula in it. thank you though.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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: how to use criteria range of variable size
    By AnnaGb in forum Excel General
    Replies: 3
    Last Post: 06-26-2010, 02:43 PM
  2. Advanced filter sort by inpur variable.
    By superkid in forum Excel General
    Replies: 1
    Last Post: 03-04-2009, 06:32 AM
  3. Advanced Filter based on variable.
    By goofy78270 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2007, 10:47 AM
  4. [SOLVED] Advanced Filter VB Script for Variable Criteria Range
    By Jason in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2006, 02:15 AM
  5. advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1