Auotofilter problem!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
Click to expand...

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
 
Back
Top