VBA to loop thru SOME (but not all) worksheets

[KatieTD21]

Newbie looking for assistance with looping thru SOME, but not all, worksheets in a workbook -

My workbook has 6 worksheets and I need to do the following for only 3 of the 6 sheets:

1. Turn off Freeze Panes
2. Turn off AutoFilterMode
3. Delete all content

I tried the code below but it only works on the active sheet. How do I get it to loop thru all 3 sheets? Any help is appreciated. Thanks.

Dim WS As Worksheet

For Each WS In Sheets(Array("Alpha", "Bravo", "Charlie"))
   ActiveWindow.FreezePanes = False
   ActiveSheet.AutoFilterMode = Flase
   Cells.Delete Shift:=xlUp
Next WS

 

[Michael M]

Maybe this...UNTESTED

Sub MM1()
Dim WS As Worksheet

For Each WS In Sheets(Array("Alpha", "Bravo", "Charlie"))
   WS.Activate
   ActiveWindow.FreezePanes = False
   WS.AutoFilterMode = False
   Cells.Delete Shift:=xlUp
Next WS
End Sub

 

[KatieTD21]

Works like a charm!!! Thank you!!!

(Now I'm embarrassed for not thinking of that. )