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

¥Îvba ¦bÀx¦s®æ¸Ì©ñ¤½¦¡¦³""""®É, ¦p¦ó¸Ñ¨M

¥Îvba ¦bÀx¦s®æ¸Ì©ñ¤½¦¡¦³""""®É, ¦p¦ó¸Ñ¨M

½Ð°Ý·Q¦bÀx¦s®æ¸Ì©ñ¤½¦¡¦³""""®É, ¦³¨Ç¥i¥H, ¦ý¦³¨Ç«o¥X²{¿ù»~, ¥i¥H½Ð¤j¤j´£¥Ü¤@¤U §Úªº»~°Ï¦b­þ? ·P¿E~~

Cells(26, 1) = "=IF(A24="","¦¨¥\","¥¢±Ñ")"  
==>¦pªG¬°ªÅ¥Õ,´N¦¨¥\,§_«h¥¢±Ñ---¤W­±³o¦æ¦bvba¸ÌÅã¥Ü¿ù»~,

Cells(26, 1) = "=IFERROR(VLOOKUP($C23,B:B,4,0),"""")"  
==>³o¦æ´N¥i¥H°õ¦æ

¦Û¤v¿ý¤@­Ó¥¨¶°¨Ó¤F¸ÑVBA¦p¦ó³B²zdouble quotation marks ""

TOP

¦^´_ 1# colorpan


    Cells(26, 1) = "=IF(A24="""",""¦¨¥\"",""¥¢±Ñ"")"

TOP

¦^´_ 3# jcchiang
·PÁ¤j¤jªº¸Ñµª^^~~

TOP

¦^´_ 2# ikboy

¹ï吔, «ç»ò¨S·Q¨ì, ¦hÁ¤j¤jªº´£¥Ü~~

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD