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

[Âà¶K] Re: (§óª©«eºô§}ªºµo°Ý¤å) ¦³Ãö¸ê®Æ®wªº°ÝÃD.........

[Âà¶K] Re: (§óª©«eºô§}ªºµo°Ý¤å) ¦³Ãö¸ê®Æ®wªº°ÝÃD.........

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-5-7 23:28 ½s¿è

¦¹½g¬°¦^ÂЧ󪩫eºô§}¤ººô¤Íªº´£°Ý, ­ìµo°Ý¤åºô§} : http://gb.twbts.com/index.php?topic=13289.0
¦]¬°¤§«eµ¥¯Å¤£¨¬µLªkŪ¨úªþÀÉ, ©Ò¥HµLªk°Ñ»P¸Ó½g°Q½×,²{¦b¯àŪ¨úÀɮפF¦ý¸Ó³B¸T¤î¶K¤å,¬G©ó¦¹³B·s¶}¦ê¦^ÂÐ.
­Y¤£¯àµo¦¹¤å·Ð½Ðª©¥D§iª¾§Ú§R°£,ÁÂÁÂ.

¤Þ¥Î­ì¤å :
baby2019451 »¡¨ì :
> 1.½Ð°Ý¸ê®Æ®w¤º2009ªºªF¦è¥¼¦ó·|Åܦ¨³o¼Ë #N/A
> 2.½Ð°Ý¯f±w¼p©Ð¦³¤@­Ó¹qªºÄæ¦ì.§Ú·Q¬O§_¥i¥H¥h§ì¡¨«×¹q¡¨¤ºªºALªº­È.
> ½Ð°Ý§Ú­n¦p¦ó°µ£»£»£»£»£»£»£»£»£»

1. 2009 ¤ºªºªF¦è¤§©Ò¥H·|Åܦ¨ #N/A ¬O¦]¬°¤½¦¡©Ò°Ñ·Ó¨ìªº $A$2AR$65536 ½d³ò¤º¦³ #N/A µ²ªGªºÀx¦s®æ, ©Ò¥H·|µo¥Í¯Á¤Þ¥¢±Ñªº±¡§Î,
½Ð±N sheets("«×¹q") ¤ºªº AL24 ¤Î¨ä¥H¤UªºÀx¦s®æ¤½¦¡­×§ï¬°¤£·|²£¥Í #N/A ªº±Ô­z.

·Ó¬Ý¨º¨ÇÀx¦s®æªº¤½¦¡³£Åܦ¨ "=¹q!#REF!" , ²q´ú¬O§A§â ¸Ó®æ©Ò°Ñ·Óªº sheets("¹q") ¤ºªºÀx¦s®æ "§R°£" ±¼, ¥H­P³sµ²³à¥¢.
«Øij§A¤U¦¸­n²M°£¸ê®Æ®É¥i¥H¦Ò¼{¥Î "²M°£¤º®e" ¦Ó¤£¬O¥Î "§R°£" Àx¦s®æªº¤è¦¡,´N¤£·|¦Aµo¥Í¦¹°ÝÃD¤F.

2. ­n§ì AL ·íµM¬O¥i¥Hªº, «e´£¬O¤W­±»¡ªº­n¥ý§â #N/A ªº­ì¦]®ø°£,¤~¯à¥¿±`§ì¨ú¸ê®Æ

book2(1).rar (21.4 KB)

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD