|
- Sub test()
- Dim arr, brr(), crr(), k As Integer, i As Integer, s As Integer, ss As Integer
- Dim m, n
- arr = Sheet1.Range("a6:am" & Sheet1.Range("c1000").End(3).Row)
- ReDim brr(1 To 100, 1 To UBound(arr, 2) - 4)
- ReDim crr(1 To 100, 1 To UBound(arr, 2) - 4)
-
- For k = 1 To UBound(arr)
- If arr(k, 3) <> "" Then
- s = 0: ss = 0
- For i = 8 To UBound(arr, 2) Step 2
- If arr(k, i) > arr(k, i + 1) Then
- If s = 0 Then m = m + 1: s = s + 1
- brr(m, 2) = arr(k, 3)
- brr(m, i - 4) = arr(k, i) - arr(k, i + 1)
- End If
- If arr(k, i) < arr(k, i + 1) Then
- If ss = 0 Then n = n + 1: ss = ss + 1
- crr(n, 2) = arr(k, 3)
- crr(n, i - 4 + 1) = arr(k, i) - arr(k, i + 1)
- End If
- Next i
- End If
- Next k
-
- Sheet3.Range("a5").Resize(UBound(brr), UBound(brr, 2)) = brr
- Sheet5.Range("a5").Resize(UBound(crr), UBound(crr, 2)) = crr
- End Sub
复制代码 |
|