|
Sub Test()
Dim ar, br, cr As Range, W, I, J, ARR
Application.DisplayAlerts = False
On Error GoTo 0
'Set ar = Application.InputBox(prompt:="请选择操作列", Title:="提示", Default:="请选择", Type:=8)
Set br = Application.InputBox(prompt:="请选择开始单元格", Title:="提示", Default:="请选择", Type:=8)
Set cr = Application.InputBox(prompt:="请选择需要保留的数据", Title:="提示", Default:="请选择", Type:=8)
Set D = CreateObject("scripting.dictionary")
Application.ScreenUpdating = False
ARR = cr
For I = 1 To UBound(ARR)
D(ARR(I, 1)) = ""
Next
W = D.KEYS
For I = Range("A65536").End(3).Row To br.Row Step -1
For J = 0 To D.Count - 1
If Cells(I, 2) = W(J) Then Exit For
Next
If J = D.Count Then Rows(I).Delete
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
VBA删除保留字符外的其它行.rar
(19.13 KB, 下载次数: 21)
|
评分
-
查看全部评分
|