- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
- Sub CommandButton1_Click()
- Dim i As Integer, A As Integer, C As Integer
- With Range("I65536").End(xlUp).Offset(1)
- .Cells = [H1]
- i = 1
- Do
- A = IIf(i = 1, i, i + 1)
- i = Application.WorksheetFunction.Find(",", .Cells, i + 1)
- C = [H1].Characters(Start:=A, Length:=i - A).Font.ColorIndex
- .Characters(Start:=A, Length:=i - A).Font.ColorIndex = C
- Loop Until i >= Len(.Cells)
- End With
- End Sub
½Æ»s¥N½X |
|