Sub Click()
Dim A, B, i, j, k
A = Sheets(1).Range("a1").CurrentRegion
B = Sheets(2).Range("a1").CurrentRegion
For i = 2 To UBound(B)
For j = 2 To UBound(B, 2)
For k = 1 To UBound(A)
If InStr(B(i, j), A(k, 1)) Then B(i, j) = VBA.Replace(B(i, j), A(k, 1), "")
Next k
Next j
Next i
With Sheets(3)
.Range("a1").CurrentRegion = ""
.Range("a1").Resize(i - 1, j - 1) = B
.Select
End With
End Sub 2015.07.16 原始数据2.rar(81.55 KB, 下载次数: 5)
Sub Click()
Dim A, B, i, j, k
A = Sheets(1).Range("a1").CurrentRegion
B = Sheets(2).Range("a1").CurrentRegion
For i = 2 To UBound(B)
For j = 2 To UBound(B, 2)
For k = 1 To UBound(A)
If InStr(B(i, j), A(k, 1)) Then B(i, j) = VBA.Replace(B(i, j), A(k, 1), "")
Next k
Next j
Next i
With Sheets(3)
.Range("a1").CurrentRegion = ""
.Range("a1").Resize(i - 1, j - 1) = B
.Select
End With
End Sub 2015.07.16 原始数据2.rar(81.55 KB, 下载次数: 5)
Sub 删除数字()
Dim arr, x
arr = Application.Transpose(Sheet1.[a1:a9])
For x = 1 To UBound(arr)
Sheet2.UsedRange.Replace arr(x), "", 2
Next
MsgBox "删除完毕!"
End Sub