The objective of this macro is to run through all worksheets (except for the first two) and delete data in
selected cells, then select cell A1 before going on to the next sheet. At the end, it should land on sheet 1.
code below does not run through any sheet except for the active one, which happens to be one of the first two sheets that I
DON'T want it to run on.
Dim wSheet As Worksheet
For Each wSheet In Worksheets
Select Case wSheet.Name
Case "Index1", "Index2"
I'm not sure what I'm missing.
Any help would be greatly appreciated.