jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 439
- Office Version
- 2016
Hey guys,
I have the following
ActiveSheet.Range("$A$1:$BS$5072").AutoFilter Field:=71, Criteria1:="<>#N/A", _
Operator:=xlOr, Criteria2:="<>"
basically I want it to filter out na and blanks and display anything else. It doesnt seem to be working, but the code isnt giving me an error. Thoughts?
Jordan
I have the following
ActiveSheet.Range("$A$1:$BS$5072").AutoFilter Field:=71, Criteria1:="<>#N/A", _
Operator:=xlOr, Criteria2:="<>"
basically I want it to filter out na and blanks and display anything else. It doesnt seem to be working, but the code isnt giving me an error. Thoughts?
Jordan