Sub xxxx() '暂停系统发出删表提示 Application.DisplayAlerts = False For Each s In Sheets If s.Name = "过去" Then s.Delete Next Application.DisplayAlerts = True End Sub
给你一个不用循环的(又叫跑圈) Sub DeleteSheet(shName As String) Application.DisplayAlerts = False On Error Resume Next Worksheets(shName).Delete On Error GoTo 0 Application.DisplayAlerts = True End Sub 没把名字写死在过程中,使用方法 Sub OkExcel() DeleteSheet "过去" End Sub