- ©«¤l
- 560
- ¥DÃD
- 159
- ºëµØ
- 0
- ¿n¤À
- 723
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2014-9-10
- ³Ì«áµn¿ý
- 2023-10-31
|
[µo°Ý] «ü©wÀx¦s®æ½d³òÅܧ󩳦âÃC¦â°ÝÃD½Ð±Ð-VBA
dear all ¤j¤j
1.«ü©wÀx¦s®æ½d³òÅܧóÃC¦â°ÝÃD½Ð±Ð
1.1 ¹Ï¤@¬°§PÂ_ì«h. 1¬°½d³ò°_©lÂI ¦p¹Ï¤@
range(a2:a3)¤@²Õ - Àx¦s®æÂÅ©³
range(a4:a6)¤@²Õ - Àx¦s®æ¬õ©³
range(a7:a7)¤@²Õ - Àx¦s®æ¶À©³
range(a8:a9)¤@²Õ........
2.¤£¦P²ÕÀx¦s®æ©³¦â¤£¦P.
3.VBA¦p¦ó®Ñ¼g,·Ð¤£§[½ç±Ð thanks *10000
¹Ï¤@
range("a2")=1
range("a3")=2
range("a4")=1
range("a5")=2
range("a6")=3
range("a7")=1
range("a8")=1
range("a9")=2.......... |
|