|
本帖最后由 ck03w11 于 2020-11-2 11:31 编辑
请教各位老师,这句代码老卡上 Cells(n, 1).Resize(1, UBound(brr, 2)) = Application.Index(brr, i, 0)是什么原因!Sub lqxs()
Dim d, arr, i&, brr, n&
Set d = CreateObject("scripting.Dictionary")
Sheet3.Activate
[a2:CR200].ClearContents
n = 1
arr = Sheet2.[a1:CR200]
For i = 2 To UBound(arr)
d(arr(i, 18)) = " "
Next
brr = Sheet1.[a1:CR200]
For i = 2 To UBound(brr)
If Not d.exists(brr(i, 18)) Then
n = n + 1
Cells(n, 1).Resize(1, UBound(brr, 2)) = Application.Index(brr, i, 0)
End If
Next
End Sub请哪位老师能不能帮我把红色的换成意思和效果一样的。谢谢!!
|
|