|
请老师编写代码:删除表格里多余的数字相同的行。谢谢!
- Private Sub CommandButton1_Click()
- Dim arr, arrtemp
- Dim rg As Range
- Dim result()
- On Error Resume Next
- Set rg = Range("a2:g23").SpecialCells(xlCellTypeBlanks)
- If Not rg Is Nothing Then rg = " "
- arr = Range("a2:g23")
- Set rg = Nothing
- Dim dic As Object, str$
- Set dic = CreateObject("scripting.dictionary")
- For i = LBound(arr) To UBound(arr)
- str = Join(WorksheetFunction.Index(arr, i, 0), "#")
- dic(str) = dic(str) + 1
- Next
- i = 0
- ReDim result(1 To dic.Count)
- For Each arrtemp In dic.keys
- i = i + 1
- result(i) = Split(arrtemp, "#")
- Next
- If dic.Count > 0 Then
- Range("j1").CurrentRegion.ClearContents
- Range("j1") = "表2"
- result = WorksheetFunction.Transpose(WorksheetFunction.Transpose(result))
- [j2].Resize(UBound(result), UBound(result, 2)) = result
- End If
- End Sub
复制代码
|
|