¦U¦ì¤j¤j¦n!
¤p§Ì·Q¥ÎVBA ¨Ï¥ÎVlookup ¸óÀɬd¸ß ¨Ï¥Î»yªk¦p¤U
¦ý¤@ª½¥X²{¿ù»~! ½Ð°Ý¸Ó¦p¦óקï??ÁÂÁÂ!!
Range("H6") = Application.IfError(Application.VLookup(Range("C6"), Workbooks(""\\HR-SERVER\webserver\³¡ªù\¬ãµo³¡\2.WSS\«Ý·|ñÀÉ®×°Ï\¾ã²z«áÁ`ªí-µ¹³¯¥ý¥Íª©¥»-20150415.xls"").Sheets("°ò¥»¸ê®Æ").Range("C:X"), 22, False), "N") |