|
本帖最后由 liulang0808 于 2020-1-8 19:37 编辑
Sub dsmch()
Application.ScreenUpdating = False
Sheet2.Activate
Set sh = ActiveSheet
tj = [b2]
With Workbooks.Open("F:\资料\资料.xlsx")
arr = .Sheets(1).UsedRange
r = 2
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
If arr(i, j) Like "*" & tj & "*" Then
r = r + 1
For X = 1 To UBound(arr, 2)
arr(i, X) = sh.Cells(r, X)
Next X
Exit For
End If
Next
Next
.Sheets(1).UsedRange = arr
.Close False
End With
Application.ScreenUpdating = True
End Sub
代码没有测试,,,,
|
评分
-
1
查看全部评分
-
|