Filter Problem??

[brettvba]

Selection.AutoFilter Field:=8, Criteria1:=(<=dollarvalue), Operator:= _
xlAnd
what is wrong with the above I want to filter to less than or equal to dollarvalue
I have dim'd dollarvalue nothing seems to work help?

[Mark W.]

Shouldn't criteria be a cell range consider of no less that 2 rows?

[brettvba]

It was recorded code I want to filter by a specified dollar amount eg $100 using a variable any other code would be of help?

[Mark W.]

Ahh, sorry thought this was an Advanced AutoFilter. Is Field 8 your dollar amount field? You should be entering <=100.

Selection.AutoFilter Field:=8, Criteria1:="<=100", Operator:=xlAnd

[ This Message was edited by: Mark W. on 2002-03-14 15:04 ]

[Steve Hartman]

On 2002-03-14 14:47, brettvba wrote:
Selection.AutoFilter Field:=8, Criteria1:=(<=dollarvalue), Operator:= _
xlAnd

Try replacing the parenthesis with double quotes and drop the operator statement

Selection.AutoFilter Field:=8, Criteria1:="<=dollarvalue"

[brettvba]

that would work for text but i'm putting a variable in their, this is an autofilter thats being customised.

[Mark W.]

On 2002-03-14 15:03, brettvba wrote:
that would work for text but i'm putting a variable in their, this is an autofilter thats being customised.

See my edited response above.

[brettvba]

I can do it to equal the variable by
Selection.AutoFilter Field:=8, Criteria1:=(dollarvalue), Operator:= _
xlAnd
but not less than or equal to?

[brettvba]

so what your saying mark is that you can't put a variable in a filter unless its equal to it?

[Aladin Akyurek]

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