|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
上传代码:
- Sub 遍历工作表取不重复()
- Dim arr, brr(1 To 4 ^ 8, 1 To 2) As String, i As Long, mSht As Worksheet, mStr As String
- Dim d As Object: Set d = CreateObject("Scripting.Dictionary")
- Dim m As Long: m = 0
- For Each mSht In Worksheets
- If mSht.Name <> "汇总" Then
- arr = mSht.UsedRange.Value
- For i = 2 To UBound(arr)
- If Len(arr(i, 1)) > 0 And Len(arr(i, 2)) > 0 Then
- mStr = arr(i, 1) & "," & arr(i, 2)
- If Not d.Exists(mStr) Then
- d(mStr) = ""
- m = m + 1
- brr(m, 1) = arr(i, 1)
- brr(m, 2) = arr(i, 2)
- End If
- End If
- Next
- End If
- Next
- With Worksheets("汇总")
- .Activate
- .Range("A2:B1048576").ClearContents
- .Range("A2").Resize(m, 2).Value = brr
- End With
- Set d = Nothing
- End Sub
复制代码
|
|