zagrijs
06-26-2014, 10:12 AM
Hi,
I have a spreadsheet that holds data of disciplinary cases. It has a date column that is completed when a case is completed.
I need to filter this column to get the cases that was completed in a particular period as well as pending cases, i.e. blank fields.
I can't make it work.
I tried several possibilities, e.g.
Activesheet.range("myRange").autofilter field:=6, criteria:=array("="), _
Operator:=xlOr, Criteria2:=">=2013/04/01", Operator:=xlAnd, Criteria3:="<=2013/06/30"
I have been working long hours for a few days and my brain is flat! I know the answer is probably staring me in the face, but I cannot see it.
Please help.
Z
I have a spreadsheet that holds data of disciplinary cases. It has a date column that is completed when a case is completed.
I need to filter this column to get the cases that was completed in a particular period as well as pending cases, i.e. blank fields.
I can't make it work.
I tried several possibilities, e.g.
Activesheet.range("myRange").autofilter field:=6, criteria:=array("="), _
Operator:=xlOr, Criteria2:=">=2013/04/01", Operator:=xlAnd, Criteria3:="<=2013/06/30"
I have been working long hours for a few days and my brain is flat! I know the answer is probably staring me in the face, but I cannot see it.
Please help.
Z