Delete sheet where name like

excel, vba

Solution

Something like this (not tested):

For Each s in ActiveWorkbook.Sheets
    If Left(s.Name, 16) = "Mgt Report as at" Then
        s.Delete
    End If
Next s

Problem

How can I delete sheet where the sheet name like ``` Left(SheetExists.Name, 16) = "Mgt Report as at" ``` Tried: ``` Sheets(Left(SheetExists.Name, 16) = "Mgt Report as at").Delete ```

Original source