Niranjanrajrishi
Member
Please help me with a VBA code to delete (the data is huge) all Rows which do not equal to the current month in the I column. The date format of I column is MM/DD/YYYY.
I could get the code to filter for current month but I am looking for other than current month.
I could get the code to filter for current month but I am looking for other than current month.
Code:
Sub DateFilter()
Sheets("BB-invoices").Range("A:AB").AutoFilter Field:=9, Criteria1:=xlFilterThisMonth, Operator:=xlFilterDynamic
End Sub