- ©«¤l
- 824
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 904
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2023-12-24
|
§ÚªºEXCEL VBA ¥Dn¥Î¨Ó§â 0-9 ªº³sÄò¼Æ¦r ¨ú¥X
²{¦bªºVBA CODE ¤ñ¸û²ÖÂØ 0-9 ´N¤w¸g¨º»ò¦hCODE¤F ...
adrian_9832 µoªí©ó 2019-3-1 21:11
¬Ý¤£À´§Aªº¨Ò¤l...
¬°¬Æ»ò¤@¶}©l 210280 »P 210281 ¤£ºâ³sÄò¼Æ¦r?
±µµÛ 21032 21033 21034 ¤]¤£ºâ³sÄò¼Æ¦r?
§A»Ýn±Ôzªº§ó²M·¡¤@ÂI,
þ¨Ç±¡§Î¤U¤£¯à¦C¤J³sÄò¼Æ¦r³B²z³á.
Y°²³]¥un¬O³sÄò¼Æ¦r³£¦C¥X¨Ó,
¨º»ò¥i¥H¥Î¤U¦¡:- Sub nn()
- Dim lRow&, lVal&
-
- lRow = 1
- lVal = -99999
- Do While Cells(lRow, 3) <> ""
- With Cells(lRow, 3)
- If .Value = lVal + 1 Then
- .Interior.ColorIndex = 34
- .Offset(, 2) = "abc"
- If .Offset(-1, 2) <> "abc" Then
- .Offset(-1).Interior.ColorIndex = 34
- .Offset(-1, 2) = "abc"
- End If
- End If
- lVal = .Value
- End With
- lRow = lRow + 1
- Loop
- End Sub
½Æ»s¥N½X |
|