help with filtering when recording

[jordanburch]

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

 

[Fluff]

In what way isn't it working?
Also are the #N/A formula errors?

 

[jordanburch]

In what way isn't it working?
Also are the #N/A formula errors?

its pulling through all data. I need to to pull through the matches with the rows only, but that could change from time to time so I want to simply exclude the na and the blanks and copy paste. I think I need an array because I want them both filtered I change it to such

ActiveSheet.Range("$A$1:$BS$5072").AutoFilter Field:=71, Criteria1:=Array( _
"<>#N/A", "<>"), Operator:=xlFilterValues

will that fix my issue?

 

[jordanburch]

its pulling through all data. I need to to pull through the matches with the rows only, but that could change from time to time so I want to simply exclude the na and the blanks and copy paste. I think I need an array because I want them both filtered I change it to such

ActiveSheet.Range("$A$1:$BS$5072").AutoFilter Field:=71, Criteria1:=Array( _
"<>#N/A", "<>"), Operator:=xlFilterValues

will that fix my issue?

so i tested it out and it errors out and does not work

 

[Fluff]

You didn't answer this part of my question
Also are the #N/A formula errors?

 

[jordanburch]

You didn't answer this part of my question
Also are the #N/A formula errors?

yes the na are caused by formula errors.

 

[Fluff]

In that case just change the xlOr in your original code to xlAnd

 

[jordanburch]

In that case just change the xlOr in your original code to xlAnd

worked like a charm thanks again fluff!

 

[Fluff]

You're welcome & thanks for the feedback.