VBA Excel Macro Filtering

Question

Getting Error 1004 i want to filter on these 3 numbers in my macro. 2 numbers work okay, but when i add criteria 3 it breaks. please help.

   ActiveSheet.Range("$A:$E").AutoFilter Field:=5, Criteria1:= _
    "<>4649566", Operator:=xlAnd, Criteria2:= _
    "<>7900559", Operator:=xlAnd, Criteria3:= _
    "<>8910907", Operator:=xlAnd

A quick check on the MSDN page for Range.Autofilter seems to indicate that only two criteria are accepted: msdn.microsoft.com/en-us/library/office/… — Dan Wagner
– Dan Wagner, Commented Jun 17, 2014 at 20:48
VBA wizard @simoco appears to have addressed a similar issue by using Array(), check the technique here: stackoverflow.com/questions/21834701/… — Dan Wagner
– Dan Wagner, Commented Jun 17, 2014 at 20:49

Anurag Singh · Accepted Answer · 2015-06-18 21:28:23Z

1

 ActiveSheet.Range("$A:$E").AutoFilter Field:=5, Criteria1:= Array("<>4649566","<>7900559", "<>8910907"), Operator:=xlFilterValues

answered Jun 18, 2015 at 21:28

Anurag Singh

1201 gold badge3 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Excel Macro Filtering

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related