jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
Hey guys,
I have this code that filters for non blanks and non na values. It worked before but keeps erroring out. any ideas?
ActiveSheet.Range("$A$1:$AY$5000").AutoFilter Field:=50, Criteria1:="<>#N/A", _
Operator:=xlAnd, Criteria2:="<>", Operator:=xlFilterValues
i get run time error 1004
autofilter method of class failed
Jordan
I have this code that filters for non blanks and non na values. It worked before but keeps erroring out. any ideas?
ActiveSheet.Range("$A$1:$AY$5000").AutoFilter Field:=50, Criteria1:="<>#N/A", _
Operator:=xlAnd, Criteria2:="<>", Operator:=xlFilterValues
i get run time error 1004
autofilter method of class failed
Jordan
Last edited: