|
本帖最后由 suntree 于 2012-5-18 14:01 编辑
- Sub test()
- Application.DisplayAlerts = False '关闭提示
- Application.ScreenUpdating = False '关闭屏幕更新,加快程序运行。
- For k = 1 To Sheets.Count
- Sheets("sheet" & k).Select
- For i = [a65536].End(xlUp).Row To 1 step -1
- For m = 1 To Len(Cells(i, 1))
- If Mid(Cells(i, 1), m, 1) = "7" Then
- Rows(Cells(i, 1).Row).Delete
- End If
- Next m, i, k
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|