Using Multiple criteria in VBA

[anshikam]

Hello,

I dont see why my code is only pulling records with criteria "DUE TODAY"

' ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=7, Criteria1:=Array("OVERDUE", "DUE", "DUE DATE PENDING", "DUE TODAY")'

I am trying to filter data based on values
("OVERDUE", "DUE", "DUE DATE PENDING", "DUE TODAY")' in column 7

Thanks

 

[Peter_SSs]

You need an extra parameter ..

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=7, Criteria1:=Array("OVERDUE", "DUE", "DUE DATE PENDING", "DUE TODAY"), Operator:=xlFilterValues

 

[anshikam]

You need an extra parameter ..

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=7, Criteria1:=Array("OVERDUE", "DUE", "DUE DATE PENDING", "DUE TODAY"), Operator:=xlFilterValues

Ok Thanks.

 

[Peter_SSs]

Ok Thanks.

You're welcome.

 

[anshikam]

You're welcome.

Thanks Peter works just fine.

 

[Peter_SSs]

Thanks Peter works just fine.