Option Explicit Sub a() Dim i%, j%, K% Dim arr, arrt() Dim d As New Dictionary arr = Range("a2:b" & [a65536].End(xlUp).Row) For i = 1 To UBound(arr) d(arr(i, 2)) = "" Next For j = 1 To d.Count d(WorksheetFunction.Large(d.Keys, j)) = j Next ReDim arrt(1 To UBound(arr)) For K = 1 To UBound(arr) arrt(K) = d(arr(K, 2)) Next [e2].Resize(UBound(arrt), 1) = WorksheetFunction.Transpose(arrt) End Sub 谢谢5楼的代码! 可以写个批注说明每句代码的意思和作用吗? 我看不懂,想研究研究,谢谢了!
[此贴子已经被作者于2009-12-11 23:56:36编辑过] |