Hi,
I have this code recorded from Excel 2013:
I have this code recorded from Excel 2013:
Code:
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