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

[µo°Ý] VBA ²M°£¡BÁÙ­ì½Ð±Ð

¦^´_ 1# ¬PªÅÉ@¦ÐÁl

³o±M¤H¥Î ­qÀ\²Î­pªí
»~«ö ²M°£ ®É¡A¤£­n¦sÀÉ¡A­«·s¶}­ì©lÀɮסA¸ê®Æ¨Ì¦s¦b¡C

µ²¦X ­Ó¤H¨C¤é­qÀ\ªí¡Aª½±µ²Î­p¤]¤£©È ²Î­pªí ²M°£¡A­«·s²Î­p´N¥i¥H

¨S¹ê½è°^Äm¡A¯Â²á¤Ñ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 21# ML089
·PÁ«e½úªº¦^ÂÐ

ªº½T¤£­n¦sÀÉ­«¶}´N¦n
¦ý¦]¬°ÁקK¤â«ü¤Ó²ßºD«öCtrl+s¤F
©Ò¥HÁÙ¬O³]­p¤@­ÓÁÙ­ì«ö¶s¤ñ¸û¦n~

¥t¥~µ²¦X­Ó¤H¨C¤é­qÀ\ªí³o­Ó«Øij«Ü¦n
¥u¥i±¤±Í¥q¬O¤H¤u¤â°Ê¥h¯È¥»ªí³æ¤W¶ñ¼g
©Ò¥H³o¤è¦¡¤£¾A¥Î¡A¦ý¬O­Ó¦nÂI¤l¡A·PÁ±z¡I

TOP

¦w¤ß¤è®×//
1) ²M°£®É¦Û°Ê³Æ¥÷¦ÜDATAªí
2) ³Ì·sªº¸ê®Æ©ñ³Ì¤W¤è¨Ã¼Ð¥Ü1, ªº¼Ð¥ÜNA, ¨C¤ëµ²§ô«á, ¥i±NNA¦æ§R°£, ¥u«O¯d²Ä¤@µ§
3) ¨C¤ë«O¯d²Ä¤@µ§, ¥iÁÙ­ìÀ˵ø, ¦ý¤ë«×ªºÁÙ­ì, ²M°£®É¤£·|¦A³Æ¥÷

Xl0000230v1.rar (20.09 KB)

TOP

¦^´_ 23# ­ã´£³¡ªL


    ÁÂÁ«e½ú«ü¾É
«e½ú¤ß«ä¿¦±K,¦Û¹Ä¥±¦p
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

§ïª©//
1) ÁקK¥»¤ëªìµLªk³Æ¥÷¤W¤ë¸ê®Æ
2) ÁÙ­ì®É¦bA1¼Ð°O¦~¤ë, ÁקK°Ê¨ìC1¤ÎF1¦ÓÂà¦sÂл\§Oªº¤ë¥÷
3) ¨C¤ë¥u«O¦s¤@µ§¸ê®Æ, ¤U¦¸²M°£ª½±µÂл\

Xl0000230v2.rar (21.09 KB)

TOP

¥u°w¹ï²M°£¤ÎÁÙ­ì¨â­Ó«ö¶s¨Ó°Ê§@¡A¤£µÛ¾¥¨ä¥L²Ó¸`¡C
Xl0000230v2.zip (27.02 KB)

TOP

¦^´_ 25# ­ã´£³¡ªL

·PÁ«e½úªº·Qªk¤Î§@ªk¤À¨É
Åý«á¾Ç¥i¥H¦h¦h¾Ç²ß¡I
·PÁ±z¡I

¥t¥~·Qªk¤À¨É
¦]¦Ò¼{¨Ï¥ÎªÌ¬°¢Ó£A¢ë¢í¢ô¤p¥Õ
¬GDATA¤À­¶¥i³]¬°ÁôÂÃ
ÁקK³Q¨Ï¥ÎªÌ»~§R
¾É­P¸ê®ÆµLªkÁÙ­ì

TOP

¦^´_ 26# Quake

·PÁ«e½úªº°µªk¤À¨É
«á¾Ç¥i¥H¦h¦h¾Ç²ß¤£¦P°µªk
ÁÂÁ¡I

TOP

¦pªG¬O©È»~IJªº¸Ü
¥[³]±K½X®Ö¹ï´N¥i¥H¸Ñ¨M
jeason

TOP

¦^´_ 29# brabus

³o¤]¬O¤@­Ógood idea
¤£¹LÁÙ¬O·|¨Ì¨Ï¥ÎªÌ¤è«K¨Ï¥Î¬°¥D~

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD