|
本帖最后由 sry660 于 2016-3-30 16:51 编辑
- Sub 最小值标注()
- Dim jmax%, imax%, i%, x#, j%
- [a1].CurrentRegion.Interior.ColorIndex = 0
- imax = Cells(Rows.Count, 1).End(3).Row
- jmax = Cells(1, Columns.Count).End(2).Column
- Application.ScreenUpdating = False
- For i = 1 To imax
- x = Application.Min(Range(Cells(i, 1), Cells(i, jmax)))
- For j = 1 To jmax
- If Cells(i, j) = x Then Cells(i, j).Interior.ColorIndex = 6
- Next
- Next
- Application.ScreenUpdating = True
- End Sub
- Sub 取消标注()
- [a1].CurrentRegion.Interior.ColorIndex = 0
- End Sub
复制代码 |
评分
-
查看全部评分
|