未测试- Sub demo()
- Dim i&, arr
- With ThisWorkbook.Sheets(1)
- arr = .Range("A3:U" & .Cells(Rows.Count, "C").End(xlUp).Row)
- For i = LBound(arr, 1) To UBound(arr, 1)
- arr(i, 20) = IIf(arr(i, 3) > arr(i, 20), arr(i, 3), arr(i, 20))
- arr(i, 21) = IIf(arr(i, 3) < arr(i, 21), arr(i, 3), arr(i, 21))
- Next
- .Range("A3").Resize(UBound(arr, 1), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码 |