Hi,
I have recorded a macro button which when pressed it currently filters the mm-mmm date in column 19 to 09-Sept or 10-Oct (current month and one month from now).
What i would like is instead of the current fixed dates, if the data could be filtered by the current month (0) and the next month (1) going by the date as if it was Today().
I cannot seem to get this work however, could someone kindly assist?
Thanks in advance!
I have recorded a macro button which when pressed it currently filters the mm-mmm date in column 19 to 09-Sept or 10-Oct (current month and one month from now).
Sub Due()
'
' Due Macro
'
'
ActiveSheet.Range("$A$3:$V$190").AutoFilter Field:=19, Criteria1:="=09-Sep" _
, Operator:=xlOr, Criteria2:="=10-Oct"
End Sub
What i would like is instead of the current fixed dates, if the data could be filtered by the current month (0) and the next month (1) going by the date as if it was Today().
I cannot seem to get this work however, could someone kindly assist?
Thanks in advance!