VBA code to apply filter based on multiple selection

[somersault]

Any idea why the below doesnt work in excel 2007??

Original code (as recorded by excel - this works well):
ActiveSheet.Range("$F$4:$G$18").AutoFilter Field:=2, Criteria1:=Array("1", "2", "3"), Operator:=xlFilterValues

Note that 1, 2, 3 are filter selection.

Dyanmic code (to make the filter selection dynamic)
r = sheets("sheet1").range("P2").value
ra = sheets("sheet1").range("P3").value
rb = sheets("sheet1").range("P4").value

ActiveSheet.Range("$F$4:$G$18").AutoFilter Field:=2, Criteria1:=Array(r, ra, rb), Operator:=xlFilterValues

i have defined the filter selections in excel range, and refered to them.

I am unable to find out my mistake, could you help??

 

[sprimax]

Hi Guys,

Can Excel 2007 do AutoFilter more than 2 criteria ? or should I used Excel 2010 ? or there's another smart way to cheat with VBA ?

Thank you

 

[Andrew Poulsom]

Custom AutoFilter allows up to 2 criteria, and you can't add more with VBA.

http://www.contextures.com/xlautofilter01.html

 

[pmich]

I am sure Mr. Poulsom may help you with a suggestion to use AdvancedFilter if you provide a sample data.

 

[Andrew Poulsom]

I am sure Mr. Poulsom may help you with a suggestion to use AdvancedFilter if you provide a sample data.

Why are you replying to a thread that's nearly four years old?

 

[pmich]

Sorry, I didn't notice it.

 

[mahindra13]

Hello,

Is there any possible to get dynamic filter criteria,like I had the data (Jan, Feb, March, April, May) these are the filter criteria's. If i select the Jan then it will shown the Jan data only. Could please help me with VBA code for above explanation.