假如第四列中某一单元格中数据小于第五列同行的数据,例如D3<E3,则D3和E3单元格中的数据互换
- Sub test()
- Dim ar, x, ls
- ar = Range("a1").CurrentRegion
- For x = 2 To UBound(ar)
- If ar(x, 4) < ar(x, 5) Then
- ls = ar(x, 5): ar(x, 5) = ar(x, 4): ar(x, 4) = ls
- End If
- Next
- Range("i1").Resize(UBound(ar), UBound(ar, 2)) = ar
- End Sub
复制代码
|