Maybe try this (untested):
![]()
For s = 1 to Sheets.Count If Sheets(s).name like "*" & "-" & "*" & "-" & "*" Then Msgbox Sheets(s).name Next
Maybe try this (untested):
![]()
For s = 1 to Sheets.Count If Sheets(s).name like "*" & "-" & "*" & "-" & "*" Then Msgbox Sheets(s).name Next
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks