PDA

View Full Version : Filter dates and blanks



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

Simon Lloyd
06-27-2014, 01:04 PM
You dont need VBA, just filter in place, here's a brilliant tutorial on all the how too's http://www.contextures.com/xladvfilter01.html