Hi,

I have the below code, and I want to repeat it for 80 sheets. The workbook has a total of 90 sheets, but I need to skip the first 10 sheets as they are different and unrelated.

Please let me know if there is a way to do this. I have tried many different solutions I have found on the internet, but I can't seem to get them to work.

Range("C1").Select
            Selection.AutoFilter
            ActiveSheet.Range("$A$1:$Y$5").AutoFilter Field:=3, Criteria1:=">1/1/2011" _
        , Operator:=xlAnd
I know that I can put the following code at the beginning to make it select a particular sheet, but I don't know how to get it to loop between sheet numbers. All of the sheets are named completely differently, so I was thinking of selecting them using the sheet code name, but I don't want to just copy paste the code 80 times and change the sheet code name. I'm assuming there is a way to loop it and it would be a very short piece of code.

Sheet10.Select
Where I would change the "10" to whatever sheet code is next. I don't know how to loop it so that the 10 changes to 11, then 12, and so on.

Thanks in advance!