|
发表于 2014-11-15 05:19
|
显示全部楼层
本楼为最佳答案
短信收到- Sub Macro1()
- On Error Resume Next
- Dim arr, d, i&, j&
- Set d = CreateObject("scripting.dictionary")
- arr = [j4:o18]
- For i = 2 To UBound(arr)
- If arr(i, 3) <> "" Then
- For j = 2 To UBound(arr)
- If arr(j, 6) = arr(i, 3) Then s = Abs(arr(i, 1) - arr(j, 4)): d(s) = j
- Next
- If Join(d.keys, "") <> "" Then
- If Application.Min(d.keys) < 4 Then '设定天数
- n = d(Application.Min(d.keys))
- arr(i, 1) = "": arr(i, 3) = ""
- arr(n, 4) = "": arr(n, 6) = ""
- End If
- End If
- d.RemoveAll
- End If
- Next
- Range("t4").Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |
|