|
发表于 2013-3-3 19:42
|
显示全部楼层
本楼为最佳答案
- Sub lqxs()
- Dim Arr, i&, Myc%
- Sheet1.Activate
- Myc = [iv4].End(xlToLeft).Column
- Arr = Cells(2, 9).Resize(2, 10)
- For j = 1 To UBound(Arr, 2)
- If Arr(3, j) > Arr(1, j) Then Arr(1, j) = Arr(3, j)
- Next
- Cells(2, 9).Resize(2, 10) = Arr
- End Sub
复制代码 |
|