|
发表于 2014-4-16 16:13
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- For i = 2 To 6 '2--6列
- r = Cells(65536, i).End(3).Row '第i列的最大行
- Set Rng = Range(Cells(2, i), Cells(r, i)) '查找区域
- Cells(3, i) = Application.WorksheetFunction.Max(Rng)
- Cells(2, i) = Application.WorksheetFunction.Min(Rng)
- Next
- End Sub
复制代码 |
|