im trying to write a macro to tidy up a workbook with allot of unnecessary sheets, what id like to do is delete all sheets the contain the word/phrase " v " (note spaces either side of the v). Browsing around i found this macro bellow, but it dose the opposite, it keeps all the sheets with " v " and deletes all the others, i just cant figure out how to get it to work the other way
Sorry if this is such an easy question, im pretty new to vba !
Sorry if this is such an easy question, im pretty new to vba !
Code:
Sub DeleteWS()
For Each ws In Sheets
Application.DisplayAlerts = False
If ws.Name <> " v " Then ws.Delete
Next
Application.DisplayAlerts = True
End Sub