Solution to delete worksheet based on worksheet name
I am providing the solution for the "Deluxe-Plus" version in the below code
To determine which worksheet is to delete, create an array called delWS(), and then loop through all the worksheet name to find the worksheet name that contains "DELETE" or "OLD".
If (InStr(WS.Name, "DELETE") <> 0 Or InStr(WS.Name, "OLD") <> 0) And InStr(WS.Name, "KEEP") = 0
Instr function is to check whether the worksheet name contains the key w...
Read More