|
本帖最后由 yorkchenshunan 于 2015-9-9 11:40 编辑
- Sub yueshengri()
- Dim dic, ar1, r%
- Set dic = CreateObject("scripting.dictionary")
- ar1 = Sheets(2).Range("a2", Sheets(2).Range("a2").End(xlDown).End(xlToRight))
- For r = 1 To UBound(ar1)
- dic(Month(ar1(r, 3))) = dic(Month(ar1(r, 3))) & "," & ar1(r, 1)
- Next r
- Sheets(1).[b1] = dic(Month(Date))
- End Sub
复制代码 |
|