- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-6-13 04:53 ½s¿è
¸g®M¨ún7822123¤j¤j즳ªºµ{¦¡½X~°ÝÃD¤w¸Ñ¨M¡C ÁÂÁÂ!
Sub Ex()
Dim i%, j%, x%, a%, max%, rg As Range
For i = 1 To 10: x = IIf(i = 10, 4, 5)
For j = 1 To 10
a = IIf(j = 10, -1, 0)
If j = 1 Then
Set rg = Cells(7 * j, 5 * i - 3).Resize(1, x)
Else
Set rg = Union(rg, Cells(7 * j + a, 5 * i - 3).Resize(1, x))
End If
Next j
rg.Interior.Color = -1 '«ì´_µL¦â
max = WorksheetFunction.max(rg)
For Each cel In rg
If cel = max Then cel.Interior.Color = RGB(255, 255, 0)
Next
Set rg = Cells(71, 5 * i - 3).Resize(1, x)
rg.Interior.Color = -1 '«ì´_µL¦â
max = WorksheetFunction.max(rg)
For Each cel In rg
If cel = max Then cel.Interior.ColorIndex = 38
Next
Next i
End Sub |
|