Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filer dates
Hi
When I use the below code for the autofilter conditions - txtStartDate and txtEndDate dosn't work. The dates are in the custom filter if I look after running the code and if I reactivate it after this everything i ok. Any help? txtStartDate and txtEndDate are input via text fields in a userform. Private Sub cmdOK_Click() if (Err) ... Else Selection.AutoFilter Field:=3, Criteria1:="=" & txtStartDate.Value, Operator:=xlAnd, Criteria2:="<=" & txtEndDate.Value End If ... End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Dates showing are not what I type | New Users to Excel | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |