|
发表于 2017-5-9 20:30
|
显示全部楼层
本楼为最佳答案
- Sub aaa()
- Dim arr, brr, i&, r&, y1, y2, y
- y1 = Range("a1048576").End(3).Row
- y2 = Range("b1048576").End(3).Row
- If y1 > y2 Then
- y = y1
- Else
- y = y2
- End If
- arr = Range("a1:b" & y)
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- If arr(i, 1) <> arr(i, 2) Then
- r = r + 1
- brr(r, 1) = arr(i, 1)
- brr(r, 2) = arr(i, 2)
- End If
- Next i
- If r > 0 Then
- [c2].Resize(r, 2) = brr
- MsgBox "different"
- Else
- MsgBox "same"
- End If
- End Sub
复制代码
|
|