vba批量删除表格

Sub clear()
Application.DisplayAlerts = False
Dim sht As Worksheet
For Each sht In Worksheets
If sht.Name <> ActiveSheet.Name Then
sht.Delete
End If
Next sht
End Sub

原文地址:https://www.cnblogs.com/yukit/p/14046728.html