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

[µo°Ý] ¤@­Ó¸òfunction ¤Î'¦³Ãöªº©_©Ç°ÝÃD

[µo°Ý] ¤@­Ó¸òfunction ¤Î'¦³Ãöªº©_©Ç°ÝÃD

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-3-8 13:38 ½s¿è



¦p¤W¹Ï

§Ú·Q§âA1ªº­È¥N¤JÅܼƤ¤ ±µªÌ¦A§Q¥Î¸Ó ª««~¦WºÙ §ä¨ì¥¦ªº¦ì¸m
¦ý°ÝÃDµo¥Í¤F

´N¹³¥ª¤W¤èÅã¥Üªº A1 ¦³30ªø«× ¦ýA2 Óý¥u¦³29 ©Ò¥H¾É­P§P©w§ä¤£¨ì

µM«á §Úµo²{ ¥u­n¥ý§âÅÜ¼Æ ª««~¦WºÙ ¥ý¼g¤J¨ìcells(2,1)¤¤´N·|Åܦ¨ªø«×29¤F(¥¿¬O§Ú·Q­nªº¼Ë¤l)

µM«á§Ú·Q§â³oªF¦è ¥[¤J¨ìfunction ¤¤ Óý«Ü©_©Çªº¬O ¥u­n°õ¦æ¨ì¦³Ãö¼g¤JÀx¦s®æ(¨Ò:cells(2,1).value=ª««~¦WºÙ)  µ{¦¡´N·|§¹¥þ¤¤Â_, ´N¹³§A®Ú¥»´N¨S¦³°õ¦æ¤@¼Ë

©Ò¥H§Ú·Qªº¬O ­n«ç°µÅý¦bfunction ¤¤§â­ì¥»A1ªºÅܼÆ(ªø«×30) Åܦ¨ A2ªº¦WºÙ(ªø«×29) ¥u¦³29®É¤~¯à¶¶§Q§Q¥Îcells.find §ä¨ì

¸Õ¤F¦n´X¤Ñ¤£ºÞ«ç¸Õ°£¥ý¼g¤JÀx¦s®æ¤¤¤£µM¥Ã»·³£¥u·|±o¨ìªø«×30ªºª««~¦WºÙ  ·PÁÂÀ°¦£~~


¥t¥~§Ú·Q°Ý¤@­Ó¤p°ÝÃD. ÅܼƥΤ¤¤å¸ò¥Î­^¤å¦b°õ¦æ³t«×¤W·|¦³®t§O¶Ü??

Book1.rar (6.01 KB)

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD