Results 1 to 4 of 4

Can't make autofilter find the number "1" and not "10"

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    DK
    MS-Off Ver
    Excel 2010
    Posts
    3

    Can't make autofilter find the number "1" and not "10"

    Hi experts,

    I have a column with data, which is controlled by autofilter in VBA. As an exampel, some of the rows contains thees data:

    Column H:
    10
    1,3,7,10
    'empty
    3,7,10

    (all in same column - H!)

    If I use the following code, all four lines returns (month=1)

    With Sheets("Costumers")
    .Range("A:ad").AutoFilter Field:=8, Criteria1:=Array("*" & month & "*", "="), Operator:=xlFilterValues
    end with
    The problem is, that "1" is also in the number "10"

    I hope you understand my qustion, 'cause it's a little difficult to explain
    Last edited by PBChristensen; 09-25-2012 at 08:23 AM.

Thread Information

Users Browsing this Thread

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

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