|
- Sub Macro1()
- Dim arr, d, i&, j&
- arr = Range("a1").CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr) - 1
- If arr(i, 1) = 5 Or arr(i, 1) = 9 Then
- GoTo line100
- Else
- For j = i + 1 To UBound(arr)
- If arr(j, 1) <> 5 And arr(j, 1) <> 9 Then
- s = Abs(arr(j, 1) - arr(i, 1))
- If Not d.exists(s) Then d(s) = arr(i, 1) Else d(s) = d(s) & "," & arr(i, 1)
- Exit For
- End If
- Next
- End If
- line100:
- Next
- MsgBox d(Application.Max(d.keys))
- End Sub
复制代码 |
|