|
本帖最后由 无忧鸟 于 2019-12-30 16:40 编辑
大师们好,因为工作需要想把sheet1放在F盘符的资料文件夹里,然后在sheet2的B2输入条件查找到F盘资料文件夹sheet1的所有数据,这个查找的路径要怎么修改,谢谢!
指定路径查找求助.zip
(18.31 KB, 下载次数: 6)
Sub dsmch()
Dim arr, d, i&, j%
Set d = CreateObject("scripting.dictionary")
Sheet2.Activate
[a5:an2000].Clear
tj = [b2]
arr = Sheet1.UsedRange
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
If arr(i, j) Like "*" & tj & "*" Then
If Not d.exists(i) Then d(i) = "": Exit For
End If
Next
Next
If d.Count > 0 Then
For Each a In d.keys
n = n + 1
Sheet1.Cells(a, 1).Resize(1, UBound(arr, 2)).Copy Cells(n + 4, 1)
Next
End If
End Sub
|
|