|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub test()
- Dim arr, brr(), i%, j%, n%, myrange As Range
- Set myrange = Sheet1.Range("A1:M" & Sheet1.Range("A1").End(xlDown).Row)
- arr = Sheet1.Range("A1:M" & Sheet1.Range("A1").End(xlDown).Row)
- ReDim brr(LBound(arr) To UBound(arr), LBound(arr, 2) To UBound(arr, 2))
- For i = 1 To UBound(arr)
- If Application.WorksheetFunction.CountIf(myrange, arr(i, 9)) = 1 Then
- n = n + 1
- For j = 1 To UBound(brr, 2)
- brr(n, j) = arr(i, j)
- Next
- End If
- Next
- [A28].Resize(UBound(arr), UBound(arr, 2)) = brr
-
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|