(¤w¸Ñ¨M)°õ¦æVBA¹q¸£ªº®Ä²v¦³¨S¦³®t?
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
(¤w¸Ñ¨M)°õ¦æVBA¹q¸£ªº®Ä²v¦³¨S¦³®t?
[i=s] ¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:09 ½s¿è [/i]
§Ú¦b§Úªº¹q¸£§¹¦¨VBA¦]¬°¦³12Ӥ몺°õ¦æ±¡§Î©Ò¥Hµ{¦¡½X¦pªG¶KWORD¦³46¶
§Ú¿ì¤½¦¡ªº¹q¸£¬OÂù®Ö¤ß¡A°õ¦æªº®ÉÔ¤j·§5-10¬í§¹¦¨
¥áµ¹¦P¨Æµ²ªG¥X²{-----¥¼µo²{±M®×
¤À§O°±¯d¦b
1. Columns("S:T").Delete Shift
Shift¡÷°±¯d¦b³o¸Ì§Ú§R±¼:=XLup
¸É¤W¤§«á´N¬OÁÙ¦³¤U±Chr¥X²{¿ù»~
2. Range("P4:P5") = "Ãä»Ú°^Äm" & Chr(10) & " ¹F¦¨"
²{¦b¥Î®a¸Ìªº¹q¸£(4®Ö¤ß)°õ¦æ¨Ã¤£·|¥X²{°ÝÃD
Ãø¹D:=XLup³oÓ³¡¤À§R±¼®e©ö¥X°ÝÃD¶Ü?
¥t¥~Chr¬O¿ý»sªºµ²ªG§Ú¨Ã¥¼×§ï¡A¬°¤°»ò¨ä¥L¦P¨Æªº¹q¸£°õ¦æ·|¥X²{°ÝÃD©O? |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
¥»©«³Ì«á¥Ñ kimbal ©ó 2010-7-14 21:02 ½s¿è
§Ú¦b§Úªº¹q¸£§¹¦¨VBA¦]¬°¦³12Ӥ몺°õ¦æ±¡§Î©Ò¥Hµ{¦¡½X¦pªG¶KWORD¦³46¶
§Ú¿ì¤½¦¡ªº¹q¸£¬OÂù®Ö¤ß¡A°õ¦æªº ...
freeffly µoªí©ó 2010-7-14 20:02
1.³o¥y¦³°ÝÃD:- Range("P4:P5") = "Ãä»Ú°^Äm" Chr(10) & " ¹F¦¨"
½Æ»s¥N½X À³¬O- Range("P4:P5") = "Ãä»Ú°^Äm" & Chr(10) & " ¹F¦¨"
½Æ»s¥N½X ¤Ö¤F¤@Ó &
2.
§Aªº project¨S¦³½sĶ¦n, ©Ò¥H¦b¥»¾÷¥Î¤Fªº¼v¹³¦æ. ¨S¦³¬d¥X { "Ãä»Ú°^Äm" Chr(10) } ³o¸Ì¦³°ÝÃD.
·í¨ì¥t¤@³¡¾÷¹B¦æ®É«·s½sĶ´N¦³°ÝÃD¤F.
¥i¥H¨ìvba¤W³o¸ÌÀˬd¤@¤U "°»¿ù->½sĶvbaproject"
°Ñ¦Ò:
http://kimbalko-chi.blogspot.com ... xcel-1997-2010.html |
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-7-14 23:10 ½s¿è
·Pı¦³°§Ú²{¦b¥´¶}¨Ó¬Ý¤º®e¬O³o¼Ë Range("P4:P5") = "Ãä»Ú°^Äm" & Chr(10) & " ¹F¦¨"
¤ñ¸û¥O¤HÃø¥H²z¸Ñªº¬O§Ú¤½¥qªº¹q¸£¦æ(¥Î¤½¥qªº¹q¸£½s¼gªº)
¦P¨Æªº¹q¸£¤£¦æ¤£¦æ
§Ú±H¦^®a¥Î¦Û¤vªº¹q¸£¶}¨S¦³³oÓ°ÝÃD
Columns("S:T").Delete Shift
¦Ó¥B³o¤@¥y¤]¤£·|¥X²{°ÝÃD
¬Ý¨Ó§Ún¦A¦^¤½¥q¸Õ¸Õ½sĶvbaproject |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|