Sub 查找断号()
Dim arr1, arr2, i As Integer, Rng As Range, onlys As New Collection, x As Integer, y As Integer 'str
r = [a65536].End(3).Row
y = Cells(r, 1) - [a1] + 1
[a1].Resize(r, 1).RemoveDuplicates Columns:=1, Header:=xlNo
arr1 = [a1].Resize(r, 1).Value
ReDim arr2(1 To y)
For x = 1 To y
arr2(x) = Format(x + [a1] - 1, "000000000")
Next x
For i = 1 To UBound(arr1)
arr2 = Filter(arr2, arr1(i, 1), False, 1)
Next i
For i = 0 To UBound(arr2)
Cells(i + 2, 3) = arr2(i)
Next i
End Sub