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

·Q½Ð±Ð¤@­ÓÀx¦s®æ½Æ»sªº°ÝÃD¡H

·Q½Ð±Ð¤@­ÓÀx¦s®æ½Æ»sªº°ÝÃD¡H

Ãö©ó½Æ»s¬Y¤@­ÓÀx¦s®æ¤º®e¦Ü¥t¤@­ÓÀx¦s®æ¡A§Ú·Q½Ð±Ð¤@¤U¤@­ÓÃþ¦ü°ÝÃD¡G
§Ú·Q­n§â¯S©w¬Y¤@®æªº¸ê®Æ¡A½Æ»s¨ì¨Ï¥ÎªÌ¡§©Ò«ü©w¡¨ªºÀx¦s®æ¡C

Ä´¦p±N¦P¤@¤u§@ªíªºA1Àx¦s®æ½Æ»s¨ìA2¡G
¥i¥H¼g¦¨ range("a2")=range("a1")

©Ò¥H¤µ¤Ñ¦pªG¥Øªº¦aÀx¦s®æ¤£©T©w¡Aµ{¦¡À³¸Ó¦p¦ó­×§ï©O¡HÁÂÁ¡C

Ãö©ó½Æ»s¬Y¤@­ÓÀx¦s®æ¤º®e¦Ü¥t¤@­ÓÀx¦s®æ¡A§Ú·Q½Ð±Ð¤@¤U¤@­ÓÃþ¦ü°ÝÃD¡G
§Ú·Q­n§â¯S©w¬Y¤@®æªº¸ê®Æ¡A½Æ»s¨ì ...
tku0216 µoªí©ó 2011-11-3 15:33



    ¦pªG¥Øªº¦aÀx¦s®æ¤£©T©w?
¨º­n¦³¬Æ»ò¨Ì¾Ú¨Ó¨M©w¥Ø¼ÐÀx¦s®æ¤~¦æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


¦hÁ¦^ÂСA   
    §Úªº³]­p»Ý¨D¬O«Ø¥ß¤@­Ó¸ê®ÆÅçÃÒªºªí®æ¡A¨Ï¥ÎªÌ¥i¥H±q¸ê®ÆÅçÃҸ̧ì¨ú©Ò»Ý­nªºªF¦è(²Î¤@¶ñ¨ìA1)¡A¤§«á¦A§âA1ªºªF¦è½Æ»s¨ìA2¡C
¤§«á¦A§ì¡A½Æ»s¨ìA3¡F¦A§ì¡A½Æ»s¨ìA4......

    ¤]´N¬O»¡¡AA1¥u¬O¤@­Ó¼È¦s®æ¡A§Úªº¥Øªº¬OA2¥H«áªºªF¦è¡C
   
     ¬G¨Ï¥ÎªÌ¦Û¦æÂI¿ï­n¦s¦b­þ¤@­ÓÀx¦s®æ¡A¤£¤@©w·Ó¶¶§Ç¡A¤]¥i¥H¸õµÛÀx¦s¡C
     ¥Ø«e¸ê®ÆÅçÃÒªº¤u§@¤w§¹¦¨¡A¥u¬O¤£ª¾¦p¦ó³B²z¸ê®Æ½Æ»sªº³¡¤À¡AÁÂÁ¡C

TOP

¦^´_ 3# tku0216


    [A65536].End(xlup).Offset(1,0)=[A1]
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


·PÁª©¥D¦^ÂСA
§Ú¸Õ¤F¤@¤U¡A´X¥G¤w¸g¬O§Ú­nªºµ²ªG¡A¤£¹LÁÙ®t¤@ÂIÂI¡A´N¬O¨Ï¥ÎªÌ¦pªG·Q­n§ó§ï¤w¸g¶ñ¼g¹LªºªF¦è¦ü¥G¨S¦³¿ìªk¡A¦]¬°µ{¦¡³]©w´N¬O¤@ª½©¹¤U¨«¡A½Ð°Ý¦³µL§ó¦nªº¿ìªk¡HÁÂÁ¡C

TOP

¦^´_ 5# tku0216

³o¬O§AªºÅÞ¿è°ÝÃD
µ{¦¡³]­p¥²¶·¬O³z¹Lµ{¦¡½XÅý¹q¸£ª¾¹D§A­n°µ¬Æ»ò
¹q¸£¤£¬O¨Ï¥ÎªÌ¨{¤l¸ÌªºµîÂÎ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# tku0216
´N¬O¨Ï¥ÎªÌ¦pªG·Q­n§ó§ï¤w¸g¶ñ¼g¹LªºªF¦è¦ü¥G¨S¦³¿ìªk
¦³¿ìªkªº,¥u¬O§A¨S¦³»¡­n¦p¦ó§ï°Ú.

TOP

¦^´_ 5# tku0216
§A¥i¥H¦Ò¼{¥Î¥t¥~¤@­ÓÀx¦s®æ¨Ó¦s©ñ¥ØªºÀx¦s®æ¦ì§},
­Y¸ÓÀx¦s®æ¬OªÅªº¨º»ò´N¨Ì¤W­±ªº¤è¦¡³B²z,
­Y¸ÓÀx¦s®æ¦³¸ê®Æ´N¥Î A1 ¨ú¥N¨ä©Ò«ü¦VªºÀx¦s®æ¤º®e.

TOP

¦hÁ¤j¤j­Ìªº«ü±Ð~~¨ü¯q­ê²L^^

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD