请问!能不能对字典内的元素排序?
我字典元素有2013,2010,2004,2014,2006,2005,2011,2012,
能不能把d.keys排序后再写入单元格?
- Sub test()
- Set d = CreateObject("scripting.dictionary")
- arr = Array(3, 1, 2, 9, 8, 7, 6, 10, 11)
- For i = 0 To UBound(arr)
- d(arr(i)) = ""
- Next
- br = d.keys
- On Error Resume Next
- For k = 0 To UBound(br)
- If br(k) >= br(k + 1) Then
- n = br(k)
- br(k) = br(k + 1)
- br(k + 1) = n
- End If
- Next
- MsgBox Join(br, "-")
- End Sub
复制代码test了一下 自己看看吧!
冒泡排序 排序方法大概有10中左右,自己简单学习一下
|