|
请参考
Sub CommandButton查找_Click1()
Set d = CreateObject("scripting.dictionary")
Application.ScreenUpdating = False
Sheet2.Activate
[a5:an4000].Clear
tj = [b3]
arr = Sheet1.UsedRange
For i = 1 To UBound(arr)
If arr(i, 2) Like "*" & tj & "*" Then
For j = 1 To UBound(arr, 2)
If Not d.exists(i) Then
d(i) = ""
r = r + 1
For x = 1 To UBound(arr, 2)
arr(r, x) = arr(i, x)
Next x
End If
Next
End If
If r >= 10 Then Exit For
Next
If d.Count > 0 Then
Sheet2.Cells(6, 1).Resize(r, UBound(arr, 2)) = arr
End If
Application.ScreenUpdating = True
Columns("a:a").NumberFormatLocal = "yyyy年m月d日"
End Sub
|
评分
-
1
查看全部评分
-
|