是这个意思不?
Sub ShtDelete
Dim m%
For m = ActiveWorkbook.Sheets.Count To 1 Step -1
Debug.Print Sheets(m).Name
If Sheets(m).Name Like "*#*" Then
Sheets(m).Delete
End If
Next m
End Sub
是这个意思不?
Sub ShtDelete
Dim m%
For m = ActiveWorkbook.Sheets.Count To 1 Step -1
Debug.Print Sheets(m).Name
If Sheets(m).Name Like "*#*" Then
Sheets(m).Delete
End If
Next m
End Sub