|
- Sub test()
- Dim r%, i%, m%
- Dim arr, brr()
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("b2:b" & r)
- For i = 2 To UBound(arr) - 1
- If (arr(i, 1) < arr(i - 1, 1) And arr(i, 1) < arr(i + 1, 1)) Or (arr(i, 1) > arr(i - 1, 1) And arr(i, 1) > arr(i + 1, 1)) Then
- m = m + 1
- ReDim Preserve brr(1 To m)
- brr(m) = arr(i, 1)
- End If
- Next
- cz = 0
- For i = 2 To UBound(brr)
- s = Abs(brr(i) - brr(i - 1))
- If cz < s Then
- cz = s
- End If
- Next
- MsgBox "最大差值为" & cz
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|