Oh, a lot of mistakes in this code.
Try this
Sub LoopSheets()
Dim oWS As Worksheet
Dim I As Long
With ActiveWorkbook
For I = 1 To .Worksheets.Count
If UCase(.Worksheets(I).Name) Like UCase("Reds*") Then
Set oWS = .Worksheets(I)
Debug.Print oWS.Name
'''my code here.
End If
Next I
End With
End Sub
or that
Sub LoopSheets1()
Dim oWS As Worksheet
With ActiveWorkbook
For Each oWS In .Worksheets
If UCase(oWS.Name) Like UCase("RedS*") Then
Debug.Print oWS.Name
'''my code here.
End If
Next oWS
End With
End Sub
Artik