|
发表于 2014-8-28 13:02
|
显示全部楼层
本楼为最佳答案
- Sub t()
- Dim arr, i&, line&, sr$, re(), cnt&, j&, k%, m&
- arr = Range("A1:E" & Cells(Rows.Count, 1).End(xlUp).Row).Value
- ReDim re(1 To UBound(arr), 1 To 2)
- sr = 258
- For i = 1 To UBound(arr)
- If sr Like "*" & arr(i, 1) & "*" Then
- cnt = cnt + 1
- sr = Replace(sr, arr(i, 1), "")
- End If
- If cnt = 2 Then
- line = i
- For j = line + 1 To UBound(arr)
- For k = 1 To UBound(arr, 2)
- If CStr(arr(j, k)) = sr Then
- re(j, 1) = 0: re(j, 2) = 0
- For m = i + 1 To j - 1
- re(m, 1) = m - i
- re(m, 2) = j - m
- Next
- sr = 258
- cnt = 0
- i = j
- GoTo nextline
- End If
- Next
- Next
- nextline:
- End If
- Next
- Range("F1").Resize(UBound(re), 2) = re
- End Sub
复制代码 |
|