已经找到批量删除指定sheet的代码了,请问如何能保留指定sheet,删除其余sheet.谢谢!!使用vba
Sub 删除指定表()
Dim Brr(1 To 20, 1 To 1)
Dim l As Integer
For l = 1 To Sheets.Count
Brr(l, 1) = Sheets(l).Name
Next
For i = 1 To Sheets.Count
If Brr(i, 1) = "汇总" Then
Else
Sheets(Brr(i, 1)).Select
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End If
Next
End Sub
把汇总改成你要保留的表名即可