I have a sheet that I want to filter on a month. I have the month in Sheet Master Cell C4.
If I use the filter as:
ActiveSheet.Range("$A$1:$X$4831").AutoFilter Field:=5, Criteria1:=xlFilterAllDatesInPeriodApril, Operator:=xlFilterDynamic
It works. When I use a variable in the AutoFiler if fails.
Full Macro is:
Dim vMonth As Variant
Dim vCrit As String
Sheets("Master").Select
Range("C4").Select
vMonth = ActiveCell.Value
vCrit = "XlFilterAllDatesInPeriod" & vMonth
Sheets("ar_report_PS_23-MAY-16").Select
ActiveSheet.AutoFilterMode = False
Cells.Select
' ActiveSheet.Range("$A$1:$X$4831").AutoFilter Field:=5, Criteria1:=xlFilterAllDatesInPeriodApril, Operator:=xlFilterDynamic
ActiveSheet.Range("$A$1:$X$4831").AutoFilter Field:=5, Criteria1:=Value(vCrit), Operator:=xlFilterDynamic
I have searched every where but cannot find a solution