customize AutoFilter
 

im trying to set autofilter to use a specific range...from what i have
learned of VBA, this seems like it should work...but it doesnt....

Range("A3").Select
Selection.AutoFilter.Range("A7:A" & Range("EndOfProducts").Offset(-1,
0).Row)

how can i get autofilter to use that range for its data....

(also as a bonus question...is there a way to toggle the autofilter
options? i would like to disable Top 10, and Custom)

Thnx