Auotofilter problem!
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 |
Auotofilter problem!
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 |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com