| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Linear Mode
