以下是引用开辆小富康在2010-3-8 17:05:00的发言: Sub 去空去重复() Dim Dic As Object, Arr, rg As Range Set Dic = CreateObject("scripting.dictionary") With Sheets("1") Arr = .Range("A11", .Range("a65536").End(xlUp)) End With For i = 1 To UBound(Arr) If Arr(i, 1) <> "" Then Dic(Arr(i, 1)) = "" Next i Set rg = Sheets("2").Range("iv6").End(xlToLeft).Offset(0, 1).Resize(Dic.Count, 1) rg.NumberFormatLocal = "@" rg = Application.Transpose(Dic.keys) Set rg = Nothing Set Dic = Nothing End Sub
Sub crdd() l = 11 With Sheets("1") For k = 11 To .[a65536].End(xlUp).Row If Len(.Cells(k, 1).Text) > 0 Then If WorksheetFunction.CountIf(.Range("a10:a" & l - 1), "=" & .Cells(k, 1).Text) < 1 Then .Cells(l, 1) = .Cells(k, 1).Text l = l + 1 End If End If Next .Range("a" & l & ":a" & k).Clear End With End Sub
Sub 去空去重复() Dim Dic As Object, Arr Set Dic = CreateObject("scripting.dictionary") With Sheets("1") Arr = .Range("A11", .Range("a65536").End(xlUp)) End With For i = 1 To UBound(Arr) If Arr(i, 1) <> "" Then Dic(Arr(i, 1)) = "" Next i Sheets("2").Columns(1).NumberFormatLocal = "@" Sheets("2").Range("A1").Resize(Dic.Count, 1) = Application.Transpose(Dic.keys) End Sub
Sub crdd() k = 1 If Cells(11, k) = "" Then Exit Sub pcol = WorksheetFunction.CountA(Sheets("2").Range("d6:cy6")) + 4 Arr = Sheets("1").Cells(11, k).Resize(1000, 1) Sheets("2").Cells(6, pcol).Resize(1000, 1) = Arr End Sub
以下是引用开辆小富康在2010-3-8 17:05:00的发言: Sub 去空去重复() Dim Dic As Object, Arr, rg As Range Set Dic = CreateObject("scripting.dictionary") With Sheets("1") Arr = .Range("A11", .Range("a65536").End(xlUp)) End With For i = 1 To UBound(Arr) If Arr(i, 1) <> "" Then Dic(Arr(i, 1)) = "" Next i Set rg = Sheets("2").Range("iv6").End(xlToLeft).Offset(0, 1).Resize(Dic.Count, 1) rg.NumberFormatLocal = "@" rg = Application.Transpose(Dic.keys) Set rg = Nothing Set Dic = Nothing End Sub