|
VBA,运行后,首先需要用户选择几个单元格(可能连续也可能分散,但都在同一列),用户确定后,高亮出最大、最小值所在行。找了很多资源,代码还是不会写。求大家帮帮忙,本人实习生,这个对我很重要,谢谢大家了!
试试看是不是这样 - Sub XXX()
- Dim Rng As Range, iMax As Range, iMin As Range
- Set iMax = Selection(1): Set iMin = iMax
- For Each Rng In Selection
- Set iMax = IIf(Rng.Value > iMax.Value, Rng, iMax)
- Set iMin = IIf(Rng.Value < iMin.Value, Rng, iMin)
- Next
- iMax.Interior.Color = vbGreen
- iMin.Interior.Color = vbYellow
- End Sub
复制代码
|
|