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.]

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.

 

[Mark W.]

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.

 

[Aladin Akyurek]

> 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.

 

[brettvba]

has anyone got straight vba to to this for me?

 

[Ivan F Moala]

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