Hey gang! Can someone please help me understand why this isn't working: the error I am getting is "Run-time error '1004: Autofilter method of Range class failed." Thank you!
Code:
Sub Criteria_Filter()
With Sheets("MASTER")
.Range("4:4").AutoFilter Field:=2, Criteria1:=Array( _
"<>TOTAL*", "<>0", "99999"), Operator:=xlFilterValues
.Range("4:4").AutoFilter Field:=7, Criteria1:=Array( _
"<>", "<>G&A"), Operator:=xlFilterValues
End With
End Sub