Auotofilter problem!

[Guest]

Why does not this work:

Selection.AutoFilter Field:=11, Criteria1:="<ActiveCell.Value"
Selection.AutoFilter Field:=13, Criteria1:=">ActiveCell.Value",
Operator:=xlOr, _Criteria2:="=Oklart"

It does not get that I want the filter to show me the values less than the
active cell value!

Thank you,
Martin

 

[Jan Karel Pieterse]

Hi Martin,

Why does not this work:

Selection.AutoFilter Field:=11, Criteria1:="<ActiveCell.Value"
Selection.AutoFilter Field:=13, Criteria1:=">ActiveCell.Value",
Operator:=xlOr, _Criteria2:="=Oklart"

Change this to:

Why does not this work:

Selection.AutoFilter Field:=11, Criteria1:="<" & ActiveCell.Value
Selection.AutoFilter Field:=13, Criteria1:=">" & ActiveCell.Value,
Operator:=xlOr, _Criteria2:="=Oklart"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com