Can i Filter on top 20 of the visible rows?

[zabiullakhan]

In the below code i want filtering on two collumns before i take Top 20 mobile models, However it dosent give me 20 records.

Can i Filter on top 20 of the visible rows?

Selection.AutoFilter Field:=2, Criteria1:="mobile" 
 
Selection.AutoFilter Field:=5, Criteria1:="india"
 
Selection.AutoFilter Field:=3, Criteria1:="20", Operator:=xlTop10Items

Please help

 

[Trevor G]

Please use the forum rules you have already posted this in a thread.

http://www.mrexcel.com/forum/showthread.php?t=535726