Autofiltering method

[krzysiek]

Hi All,

Possibly someone from You can see a mistake in below code:

            Worksheets("Relevant").Range("A1").AutoFilter Field:=10, Criteria1:=Array("[5", "[6", "{3", "{4", "<1", "<2", "<3", "<4"), Operator:=xlFilterValues

I need to filter these values in column J and when executing this code it I receive an error 1004: Autofilter merhod of Range class failed

I will be bery

 

[venkat1926]

I think this will be enough



Range("A1").AutoFilter field:=Range("J1").Column, Criteria1:=Array("2", "3", "4"), Operator:=xlFilterValues

experiment on a sample data.