ªð¦^¦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 : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD