I am getting a runtime error 1004 related to auto filtering and this is the piece of code that is highlighted in yellow when I open the debugger. But I am not seeing an error here. Can you please point it out? Thanks!
' Filter Drop Date - Field 12
ActiveSheet.Range("$A$1:$L$5000").AutoFilter Field:=12, Operator:= _
xlFilterValues, Criteria2:=Array(2, a)
What I have tried:
I have tried unfiltering the source data and refiltering to no avail.