loop through autofilter dropdown
 

I currently have a macro that works off filtered data. I use the dropdown
menu to select filter, then run macro. I would like to insert a loop at the
begining of macro that will start with the first item of dropdown menu AFTER
custom. top 10,etc dont not suit my needs with this project. The current
autofilter is located on sheet4 a1. I dont know how to tell excel to loop
through the drop down.


Thanks,
Jack