- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2022-7-26
|
¥»©«³Ì«á¥Ñ owen06 ©ó 2014-11-21 11:29 ½s¿è
¦^´_ 1# lionliu
½Ð°Ý¬OnÅý¥»¨ÓªÅ¥ÕªºchknoÄæ¡A¦Û°Ê²£¥Í¥X½s¸¹¶Ü¡H
¦pªG¬Oªº¸Ü¸Õ¸Õ¬Ý³o¼Ë¡C- Sub chkno()
- Dim rcnt As Integer
- Dim i, J As Integer
- rcnt = Cells(Rows.Count, 2).End(xlUp).Row
- For i = 5 To rcnt
-
- If Cells(i, 3) <> Empty Then
- J = J + 1
- Cells(i, 1) = J
-
- Else
- Cells(i, 1) = ""
-
- End If
-
- Next i
- End Sub
½Æ»s¥N½X |
|