¸ß°Ý§Q¥ÎVBAªºFor°j°é±a¤J¸ê®Æ¨ìÀx¦s®æ¤ºªº¼gªk
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- 2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-7-24
- ³Ì«áµn¿ý
- 2015-11-20
|
¸ß°Ý§Q¥ÎVBAªºFor°j°é±a¤J¸ê®Æ¨ìÀx¦s®æ¤ºªº¼gªk
·Q¸ß°Ý¹³³o¼ËÅýD¦Cªº¸ê®Æ¥ÑVBA±a¤Jªº¸Ü
Yn¨Ï¥Îfor°j°é ¦Û°Ê¼g¤Jn«ç»ò¼g©O....
¦]¸ê®Æ¨Ã¨S¦³³o»ò¤Ö...
[D1].Formula = "1"
[D2].Formula = "2"
[D3].Formula = "3"
[D4].Formula = "4"
[D5].Formula = "5" |
|
|
|
|
|
|
- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-9-3 17:54 ½s¿è
¦^´_ 1# toromru
Sub ¨Ì§Ç¶ñ¤J()
For i = 1 To 830
Range("D" & i + 1) = i + 1
Next
End Sub |
|
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- 2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-7-24
- ³Ì«áµn¿ý
- 2015-11-20
|
¥»©«³Ì«á¥Ñ toromru ©ó 2015-9-3 18:39 ½s¿è
¦^´_ 2# starry1314
±z¦n
¥Dn¬O ±q³o»yªk ¦p¦ó§ï? [D1].Formula = "1"
¬O§ï¦¨?
For i = 1 To 830
["D" & i + 1].Formula = i
Next
°õ¦æ«á ĵ¥Ü ¦¹³B»Ýnª«¥ó!!! |
|
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- 2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-7-24
- ³Ì«áµn¿ý
- 2015-11-20
|
¦^´_ 2# starry1314
Sorry
§Ú¤wª¾¹D «ç¼g¤F «D±`·PÁ§Aªº»yªk~
¥i¥H¨Ï¥Îò!! |
|
|
|
|
|
|