|
- Sub test()
- Dim arr, er(), x&, y As Byte
- arr = Range("a1").CurrentRegion.Value
- On Error Resume Next
- Range("f:i").Clear
- ReDim er(1 To UBound(arr), 1 To 4)
- For x = 1 To UBound(arr)
- If Format(arr(x, 4), "yyyy-m-d") <> Format(arr(x + 1, 4), "yyyy-m-d") Then
- k = k + 1
- For y = 1 To 4
- er(k, y) = arr(x, y)
- Next
- End If
- Next
- With Range("f1")
- .Resize(k).NumberFormatLocal = "@"
- .Resize(k, 4) = er
- .CurrentRegion.Borders.ColorIndex = 0
- End With
- End Sub
复制代码 |
|