Problem with multiple criteria in VBA

[Klash Ville]

I have the following code:

.Range.AutoFilter Field:=.ListColumns("Type").Index, Criteria1:="=Phone", Operator:=xlAnd, Criteria2:="=Router", Operator:=xlAnd, Criteria3:="=Telecommunications Equipment", Operator:=xlAnd, Criteria4:="=Network Product", Operator:=xlAnd, Criteria5:="=Headset"

When running this code, the following error message returns:


Run time error '91':

Object Variable or With Block variable not set

 

[Joe4]

Just to be 100% sure, I need to apply this sort of advanced filtering logic?

That appears to be what you are after.

Note that you may be able to get some of the VBA code you need by using the Macro Recorder and recording yourself performing those steps manually.