VBA Code to Select Filter Variables

[kentster]

Hi,

I have this code recorded from Excel 2013:

 ActiveSheet.Range("$A$5:$BY$922").AutoFilter Field:=31, Criteria1:=Array("0"), Operator:=xlFilterValues, Criteria2:=Array(0, "1/0/1900")

[end code]

It errors our if one of the variables is missing.  I can't have it do that.

I need it to capture either 0, 1/0/1900, or both.  The worst case is if none of them exist then is it feasible to use On Error GoTo Practice: at the beginning of the code?  And then under Practice: I would just have the same code but different variables....

I am doing this for 7 different columns and each column has the same criteria.  Once I get the first niled down, it should be a piece of cake for the others as I just change the "Field:=" value to match the column and the variables and the "On Error GoTo xxxxxx:"

Thanks again
Kent

 

[kentster]

FYI - I went a different route and this is no longer needed. I couldn't find a way to delete the original post.