Autofilters

[eqbal]

Hi,

This is the method in which we use the autofilter according to Excel’s VBA help: expression.AutoFilter(Field, Criteria1, Operator, Criteria2, VisibleDropDown).
I have a sheet in which I want to filter my accounts that are in range “G:G” according to the criteria that are put in range “P:P” as is shown below:

Criteria:

Banks
Customers
Sells
.....

How should I use the above code? What is “expression”? What is “Field” ( is it a range)?

 

[Juan Pablo González]

Are you trying to autofilter with more than 2 conditions ? that's not possible. You'll have to use Advanced filter (Which may suit a lot more in your case !), and you can even record a macro while you do that to get the proper structure.

 

[eqbal]

Hi,

Tnx for ur reply to my post: autofilter. No I'm not going to use autofilter with 2 or more conditions. I have written a code that autofilters some range criteria by criteria (the criteria := sheets(1).cells(12,i) ). It worked at first but after running and debugging 2 or 3 times the code (the autofilter code was untouchd)encounters a 1004 runtime error, which is quite ilogical.

I think that it is because I don't know the method in which the autofilter should be used.

 

[eqbal]

Couldn't any body give me a clue?