|
欲将下述代码扩展运用到工作表1-210,红色部分是添加的,出错。如何修改?恳望得到帮助。
Sub 提取()
Dim ar, x, k, br(1 To 30000, 1 To 1)
For y = 1 To 210
Sheets(y).Select
Range("d:d").ClearContents
ar = Range("c1:c" & [c65500].End(3).Row)
For x = 1 To UBound(ar)
If Application.CountIf(Range("a:b"), ar(x, 1)) = 0 Then
k = k + 1
br(k, 1) = ar(x, 1)
End If
Next
[d1].Resize(k) = br
Next
End Sub
本帖最后由 gdpgdp317 于 2015-3-4 20:05 编辑
Sub 提取()
Dim ar, x, k, br(1 To 30000, 1 To 1)
For y = 1 To 210
Sheets(y).Select
Range("d:d").ClearContents
k=0
ar = Range("c1:c" & [c65500].End(3).Row)
For x = 1 To UBound(ar)
If Application.CountIf(Range("a:b"), ar(x, 1)) = 0 Then
k = k + 1
br(k, 1) = ar(x, 1)
End If
Next
[d1].Resize(k) = br
erase br
Next
End Sub
看看可不可以?
|
|