ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

(¤w¸Ñ¨M)°õ¦æVBA¹q¸£ªº®Ä²v¦³¨S¦³®t?

(¤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¸Ñ

¦^´_ 3# freeffly


    Columns("S:T").Delete
¾ãÄæ§R°£¥u¦³¹w³]xltoleft
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ 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¸Ñ

TOP

¥»©«³Ì«á¥Ñ 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:
  1.     Range("P4:P5") = "Ãä»Ú°^Äm" Chr(10) & "    ¹F¦¨"
½Æ»s¥N½X
À³¬O
  1.     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
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD