请各位老师怎样简化下列一段代码,多谢。
Sub 清除座位表()
Dim sh As Worksheet
For Each sh In Worksheets
If sh.Name Like "*教室" Then
Application.DisplayAlerts = False
sh.Delete
End If
Next
Application.DisplayAlerts = True
Dim shs As Worksheet
For Each shs In Worksheets
If shs.Name Like "*班" Then
Application.DisplayAlerts = False
shs.Delete
End If
Next
Application.DisplayAlerts = True
End Sub