|
- Sub aa()
- Dim arr1, arr2, arr
- Dim n As Long, i As Long, j As Long
- n = [B65536].End(xlUp).Row
- n = IIf([G65536].End(xlUp).Row > n, [G65536].End(xlUp).Row, n)
- arr1 = Range("B3:D" & n)
- arr2 = Range("G3:I" & n)
- ReDim arr(1 To UBound(arr1), 1 To 7)
- n = 0
- For i = 1 To UBound(arr1)
- If arr1(i, 3) <> arr2(i, 3) Then
- n = n + 1
- arr(n, 7) = arr1(i, 3) - arr2(i, 3)
- For j = 1 To 3
- arr(n, j) = arr1(i, j)
- arr(n, 3 + j) = arr2(i, j)
- Next j
- End If
- Next i
- Range("L3:R" & [R65536].End(xlUp).Row).ClearContents
- Range("L3").Resize(UBound(arr), 7) = arr
- End Sub
复制代码 |
|