|
本帖最后由 Tank008 于 2015-10-29 11:26 编辑
- Sub 分段月份()
- Dim arr, iRows As Long
- iRows = Sheets("表2").Range("C65536").End(xlUp).Row
- arr = Sheets("表2").Range("C4:C" & iRows)
-
- Dim i As Long, brr(1 To 100000, 1 To 1), k As Long
- brr(1, 1) = Format(arr(1, 1), "yyyy年mm月")
- brr(2, 1) = arr(1, 1)
- k = 2
- For i = 2 To UBound(arr)
- If Format(arr(i, 1), "yyyy年mm月") = Format(brr(k, 1), "yyyy年mm月") Then
- k = k + 1
- brr(k, 1) = arr(i, 1)
- Else
- k = k + 1
- brr(k, 1) = Format(arr(i, 1), "yyyy年mm月")
- k = k + 1
- brr(k, 1) = arr(i, 1)
- End If
- Next i
- Sheets("表1").Range("M2").Resize(k) = brr
- End Sub
复制代码 |
|