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

[µo°Ý] ¦p¦ó§PÂ_Äæ¦ì­È¬°#REF!©Î¬O#N/A¡H

[µo°Ý] ¦p¦ó§PÂ_Äæ¦ì­È¬°#REF!©Î¬O#N/A¡H

½Ð°Ý¦bVBAµ{¦¡¤¤¡AÀ³¦p¦ó¥¿½T¥h§PÂ_¬Y«ü©wÄæ¦ìªº¥Ø«e¦s­È¬°#REF!©Î¬O#N/A¡H
§Ú¸Õ¹L¨Ï¥Î IsNull() ¨ç¼Æ¡A¦ý«D¥¿¸Ñ¡C
Ä´¦p¡G  ¥Ø«e A1Äæ¦ì ->  #REF!¡A C1Äæ¦ì ->  #N/A
¨º¦p¦ó¯à±oª¾¦¹¨âÄ檺¥Ø«e­È¬O#REF!©Î¬O#N/A¡H ¦p¦¹«áÄòªº³B²z¤~¤£­P²£¥Í«¬ºA¤£²Åªº
¿ù»~°T®§¡C
ÁÂÁ¦U¦ì¥ý¶i«ü¾É¡I

¦^´_ 1# c_c_lai


    iserror([A1])
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
ÁÂÁ±z¡I §xÂZªº°ÝÃD²×©ó¸Ñ¨M¤F¡I
¤§«e¤@ª½¦b IsNull() ¤Î Null »yªk¤W¥´Âà¡C

TOP

¦^´_ 3# c_c_lai
MsgBox [A1].Text

TOP

¦^´_ 4# GBKEE
ÁÂÁ±z¡I¤µ±á°ÝÃD¤w¸Ñ¨M¤F¡A
§Ú¬O³o»ò³B¸Ìªº¡G
    ' MsgBox [A5].Text
    If IsError([A5]) Then
        Cv = 0
    Else
        Cv = [A5].Value       ' ¦¨¥æ»ù
    End If

TOP

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