Results 1 to 3 of 3
  1. #1
    cbake is offline Member
    Join Date
    Feb 2012
    Posts
    1
    Rep Power
    0

    Default Multiple criteria autofilter, one column

    Hi,

    Basically my problem is that I want to autofilter one column using four criteria. I have the user input information into cells q2,q3,r2,r3.
    I want the autofilter to filter for all four of these inputs. Currently I have only been able to get it to filter for two of the inputs.


    Range("h:h").AutoFilter 8, Range("q2"), xlOr, Range("q3")

    Is there any way for me to autofilter all four cells in the one column. I was looking at putting the ranges in an array, but that did not work. Help would be greatly appreciated! :)

  2. #2
    Norm's Avatar
    Norm is online now Moderator
    Join Date
    Jun 2008
    Location
    Eastern Florida
    Posts
    16,586
    Rep Power
    23

    Default Re: Multiple criteria autofilter, one column

    What packages and classes are you using in your program?
    Is this a java programming problem?

  3. #3
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,189
    Rep Power
    19

    Default Re: Multiple criteria autofilter, one column

    Looks like VBA to me.

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

Similar Threads

  1. Multiple column in combo box
    By ashin in forum SWT / JFace
    Replies: 2
    Last Post: 02-04-2011, 09:27 AM
  2. Replies: 1
    Last Post: 07-06-2010, 04:50 PM
  3. Need help on Multiple Column Tree - SWT
    By esanin in forum SWT / JFace
    Replies: 0
    Last Post: 09-09-2009, 03:07 PM
  4. How to set the AutoFilter to Excel Sheet with Wither POI or JXL
    By lnarayana_boga in forum Advanced Java
    Replies: 0
    Last Post: 01-29-2008, 09:05 AM
  5. Autofilter and POI-HSSF
    By nefarius in forum JDBC
    Replies: 0
    Last Post: 09-23-2007, 03:40 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •