或是能注释一下,方便我再学习吗? Sub 白开水() Dim arr, arr1, arr2, ayy(0 To 100, 0 To 100) Set sht1 = Sheet1 Set sht2 = Sheet2 On Error Resume Next i = sht2.Range("a65536").End(xlUp).Row arr = sht2.Range("n4:x" & i) '将现住地址国标编码和疾病编码输入数组,下边的字典用法不太懂! Set dc = CreateObject("scripting.dictionary") Set dr = CreateObject("scripting.dictionary") For x = 1 To UBound(arr) If Not dr.exists(arr(x, 1)) Then k = k + 1 dr.Add arr(x, 1), k ayy(k, 0) = arr(x, 1) End If If Not dc.exists(arr(x, 11)) Then m = m + 1 dc.Add arr(x, 11), m ayy(0, m) = arr(x, 11) End If ayy(dr(arr(x, 1)), dc(arr(x, 11))) = ayy(dr(arr(x, 1)), dc(arr(x, 11))) + 1 Next sht1.[f28].Resize(k, m).ClearContents sht1.[f28].Resize(k, m) = ayy MsgBox "完成了~" End Sub
[此贴子已经被作者于2010-12-17 10:55:01编辑过] |