Filter Problem?? - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Filter Problem??

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    On 2002-03-14 15:11, brettvba wrote:
    so what your saying mark is that you can't put a variable in a filter unless its equal to it?
    You're filtering on the values in a given column. There are several choices for relatons operator: Greater than, Begins with, etc. ...Just to list a few.

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-14 15:12, Aladin Akyurek wrote:
    On 2002-03-14 15:05, brettvba wrote:
    I can do it to equal the variable by
    Selection.AutoFilter Field:=8, Criteria1:=(dollarvalue), Operator:= _
    xlAnd
    but not less than or equal to?
    Would the & trick not work -- Criteria1:="<="&E1 where E1 houses a crit value?

    Aladin
    Not for a recorded macro. Record one. And, see what happens.

  3. #13
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,772
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    > Would the & trick not work -- Criteria1:="<="&E1 where E1 houses a crit value?
    > Not for a recorded macro. Record one. And, see what happens.


    I was thinking the straight VBA.

  4. #14
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    has anyone got straight vba to to this for me?

  5. #15
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-14 15:05, brettvba wrote:
    I can do it to equal the variable by
    Selection.AutoFilter Field:=8, Criteria1:=(dollarvalue), Operator:= _
    xlAnd
    but not less than or equal to?
    [/quote]

    Would the & trick not work -- Criteria1:="<="&E1 where E1 houses a crit value?

    Aladin
    [/quote]

    Yes that should work...in brettvba's case
    it would be

    Criteria1:="<=" & dollarvalue

    The dollarvalue being his Dim variable


    Ivan

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com