- Sub YuBa()
- Dim arr, i%, s$, m$
- s = [m3]
- arr = Range("e2:e" & [e65536].End(3).Row + 1)
- m = arr(1, 1)
- For i = 1 To UBound(arr) - 1
- If arr(i + 1, 1) - arr(i, 1) > 1 Then
- m = m & "-" & arr(i, 1) & "," & arr(i + 1, 1)
- End If
- arr(i, 1) = s & "." & Format(arr(i, 1), "000")
- Next
- [b2:b1000] = ""
- [m4] = m
- [b2].Resize(i - 1) = arr
- End Sub
复制代码
|