VBA to filter everything but current month dynamically

[dshafique]

Hi everyone trying to dynamically filter out items which are NOT the current month.
currently All i was able to come up with was:

   ActiveSheet.ListObjects("TempMaster").Range.AutoFilter Field:=9, Criteria1:="<>" & xlFilterThisMonth, Operator:=xlFilterDynamic

but this doesnt seem to work.

any help would be greatly appreciated

 

[portews]

Shamelessly modified from
Can I filter data to show current month in VBA?

ActiveSheet.Range("B:B").AutoFilter Field:=1, Operator:=xlOr, _
 Criteria1:="<" & Application.EoMonth(Now, -1), _
 Criteria2:=">=" & Application.EoMonth(Now, 0)

 

[kevin9999]

If by:

filter out items which are NOT the current month

you mean that you only want to show the current month, then this should work:

Sub Show_This_Month_Only()
    With ActiveSheet.ListObjects("TempMaster").Range
        .AutoFilter 9, 7, 11
    End With
End Sub