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

Åܰʽd³ò¦WºÙ

Åܰʽd³ò¦WºÙ

§Ú¦bVBA³]¤F¤@­Ó½d³ò¦WºÙ. ¦^¨ì¤u§@ªí¬Ý¦WºÙ簵²z­û,¦¹½d³ò¦WºÙ¸Ì­±ªº"­È" & "°Ñ·Ó¨ì" ³£¬O#N/A
¥[¤W vlookup($D3,DataRange,E$2,0) ¤]§ä¤£¨ì¸ê®Æ
½Ð±Ð­n¦p¦ó­×§ï?
    Selection.CurrentRegion.Select
    ThisWorkbook.Names.Add "DataRange", myRng
fangac

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD