|
原代码作了最小改动。
- Sub aaa()
- Dim arr, brr, brr1, crr, i&, j&, k&, s$, s1$
- arr = [e2].CurrentRegion
- s1 = InputBox("Pls Input...")
- For i = 2 To UBound(arr)
- ReDim crr(Split(arr(i, 1), "-")(0) To Split(arr(i, 1), "-")(UBound(Split(arr(i, 1), "-"))))
- brr = Split(arr(i, 1), ",")
- For j = 0 To UBound(brr)
- brr1 = Split(brr(j), "-")
- For k = brr1(0) To brr1(1)
- crr(k) = 1
- Next k
- Next j
- brr = Split(s1, ",")
- For j = 0 To UBound(brr)
- brr1 = Split(brr(j), "-")
- For k = brr1(0) To brr1(UBound(brr1))
- crr(k) = ""
- Next k
- Next j
- For j = LBound(crr) To UBound(crr) - 1
- If crr(j) = 1 Then
- For k = j + 1 To UBound(crr)
- If crr(k) = "" Then Exit For
- Next k
- s = s & "," & j & "-" & k - 1
- j = k
- End If
- Next j
- arr(i, 3) = Mid(s, 2)
- s = ""
- Next i
- [e2].Resize(UBound(arr), 3) = arr
- End Sub
复制代码 |
|