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

½Ð°Ý¦p¦ó§R°£¦h¾lªÅ¥Õªº¸ê®Æ¦C

½Ð°Ý¦p¦ó§R°£¦h¾lªÅ¥Õªº¸ê®Æ¦C

½Ð°Ý¦U¦ì¥ý¶i
¦³®É­Ô·í§Ú­Ì·|®³¨ì¦³®æ¦¡ªºExcel¸ê®Æ¡A¦ý¬O³o¼Ëªºªí®æ¹ï­n°µ¸ê®Æ¤ÀªR³B²z«Ü³Â·Ð¡A
³o¥÷¸ê®Æ¡A¨C¹j´Xµ§ªÅ¥Õ¡A¤S­«ÂФW­zªº¸ê®Æ¡A½Ð°Ý¦p¦ó§R°£³o¨Ç¦h¾lªÅ¥Õªº¸ê®Æ¦C
Åý¥¦¦¨¬°¥¿³Wªº¸ê®Æªí..ÁÂÁÂ

¥h°£ªÅ¥Õ¦h¾l¦Cªº¸ê®Æ.rar (4.15 KB)

¥¦ªº½s¸¹¬O³sÄòªº
©Ò¥H§â¸ê®Æ¿ï°_¨Ó¡A«ö½s¸¹±q¤p¨ì¤j±Æ§Ç¡C
§A­nªº¨º¨Ç¸ê®Æ´N·|¨Ä¨Äªº¦b¤W­±¤F¡C

TOP

¶W¯Åª©¥Dªº ¥¨¶°«ü¥O§Ú¤@­Ó³£¬Ý¤£À´°Ú¡A­n«Üªø®É¶¡¬ã¨s¤@¤U

­ì¨Ó¡A·Q§R°£ªÅ¥Õ¦C¡A¤]¦³«Ü¦h¤è¦¡ªº¡A¨þ¡C

TOP

ª½±µ¿ï¨ú¾ã­Ó column, ¥Î¡§¿z¿ï¡¨¿ï¥X©Ò¦³ªÅ¥Õ row, ¥þ³¡§R°£«á¡A ¦A¨ú®ø¡§¿z¿ï¡¨§Y¥i¡C

TOP

¦^´_ 8# jennylu520


    ±z°µªº¤è¦¡«Ü¦n£«....´N¬OEXCELªº°ò¥»¥\
      ÁÙ¥i¥H¥t¥~¾ÇHSª©¥Dµ¹ªº¤è¦¡..«Ü¬Ûªñ³á
      VBAµ{¦¡½Xªº³¡¥÷..¦]¬°«á¨Ó¤w¸g·|¤F..©Ò¥H¨S¦³¦A¦^¤å
      ±z¥i¥H®Ú¾ÚHSª©¥Dµ¹ªºµ{¦¡½Xª½±µ¸Õ¸Õ¬Ý..
    ÁÂÁ±zªº¦^¤å....
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

§Ú¤£¤Ó·|¥Î VB¡A©Ò¥H¥Î¤F¤U­±ªº¤è¦¡

(1) ¤u¨ã¦C ¡÷  ½s¿è \ ¨ì  ==>¡u¯S®í¡v ==>¿ï¾Ü ¡uªÅ®æ¡v «á«ö½T©w

(2) §ä¨ìªÅ¥ÕÀx¦s®æ«á¡A«ö¥kÁä¡A§R°£¡i¤U¤èÀx¦s®æ¤W²¾¡j«á«ö½T©w

(3) ªÅ¥Õ¦C´N·|¦Û°Ê§R±¼©¹¤W±µÄò¹Æ


³o¼ËOK¶Ü?

TOP

¦^´_ 7# PD961A


    ¥i¨£§A®Ú¥»¨S¦³¤F¸Ñµ{¦¡½X,¥u¬O¤@¨ý®M¥Î
§Ú´£¨Ñªºµ{¦¡½X¬O°w¹ï§@¥Î¤¤ªº¤u§@ªí¸ê®Æ°µ¾ã²z
¥u­n§A§â­ìSHEET1ªº¸ê®Æ½Æ»s¨ìSHEET2«á°õ¦æ´Nª¾¹D¬O¬Æ»ò­ì¦]¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# asimov

ÁÂÁ±z
¦ý¬O¨Ì·Ó±zªº¨BÆJ¥L·|Åã¥Ü¨ì¥t¤@­Ó¦Û¿ïªºÀx¦s®æ.¨Ã¥B¥²¶·¹w³]·Ç«h½d³òÄæ
©Ò¥H¸ê®Æ¿z¿ï«á¤£·|¬O¦b­ì¨ÓªºA~Bªº¦ì¤l...ÁÙ¬OÁÂÁ±zªº¦^¤å



TOP

¥t¥~¤£¦n·N«ä¥¦¥i¥H¤£¥Î¥Î¨ìVBA¶Ü??ÁÂÁÂ!!
PD961A µoªí©ó 2010-7-17 15:28



¦pªGAÄæ¬O¼Æ¦r½s¸¹
¥i¥H¥Î¶i¶¥¿z¿ï
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 5# PD961A


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD