Hi everyone trying to dynamically filter out items which are NOT the current month.
currently All i was able to come up with was:
but this doesnt seem to work.
any help would be greatly appreciated
currently All i was able to come up with was:
VBA Code:
ActiveSheet.ListObjects("TempMaster").Range.AutoFilter Field:=9, Criteria1:="<>" & xlFilterThisMonth, Operator:=xlFilterDynamic
but this doesnt seem to work.
any help would be greatly appreciated