VBA dynamically exclude value in filter

[tgmvba]

I was wondering if anybody can tell me how to exclude a specific value from a filter after I run my macro. I have the code at the end so it runs last however I am needing to always exclude 0 and #N/A from the output. I cannot tell it what values to include because they change with every run of the macro. So I can only tell it what to filter out. Currently the code I am running is:

Sheets("QuickBase Import").Range("$A$3:$T$1131").AutoFilter Field:=20, Criteria1:= _
"<>0"
Sheets("QuickBase Import").Range("$A$3:$T$1131").AutoFilter Field:=3, Criteria1:= _
"<>#N/A"

However the issue is that the filter will filter out values other than these two which is not ideal. Thanks

 

[igold]

Could you deal with the 0 and the #NA after the macro but before the filter, something like this perhaps for the 0 in column T...

Dim rng As Range, i As Long
 Set rng = Range("T3:T1131")
 For i = 1 To rng.Cells.Count
     If rng.Cells(i) = 0 Then rng.Cells(i) = ""
 Next