My garden almanac worksheet records actioned dates for various tasks. The gardening year runs 1 Oct -- 30 Sep.
I am trying to filter out text/blank cells in a column all other entries are dates in the format: 22/10/2022
The range of dates spread over two years -- 1 Oct to 30 Sep. The following code results in filtering out all except the 'previous' year entries - i.e. 1 Oct to 32 Dec. Where have I gone wrong please?
'show only dates in Action Date column
With objList.Range
.AutoFilter Field:=lngFilter1, _
Operator:=xlFilterDynamic, _
Criteria1:=xlFilterLastYear, _
Operator:=xlAnd, Criteria2:=xlFilterYearToDate
End With
Many thanks in anticipation.
Beepee
I am trying to filter out text/blank cells in a column all other entries are dates in the format: 22/10/2022
The range of dates spread over two years -- 1 Oct to 30 Sep. The following code results in filtering out all except the 'previous' year entries - i.e. 1 Oct to 32 Dec. Where have I gone wrong please?
'show only dates in Action Date column
With objList.Range
.AutoFilter Field:=lngFilter1, _
Operator:=xlFilterDynamic, _
Criteria1:=xlFilterLastYear, _
Operator:=xlAnd, Criteria2:=xlFilterYearToDate
End With
Many thanks in anticipation.
Beepee
