Hi All,
I am running a macro loop on several worksheets in a workbook and it works, but I would like to exclude worksheets that have "14" or "15" in their name (for example Jan14, Feb14, Jan15). How can I do this? The code below doesn`t work, the loop still runs on those worksheets with "14" or "15" in their name.
(I have just put the code I am looping as "`loop Code" as that works fine, no need to look into it.)
Could someone help me with this? Cheers, A.
End SubSub KincM10WorksheetLoop() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If InStr(ws.Name, "*14") = 0 Or InStr(ws.Name, "*15")=0 Then ws.Activate ` loop Code End If Next ws
Bookmarks