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

[µo°Ý] Vlookupªº table_Array ¦p¦ó§ï¬°ÅܼÆÀ³¥Î

[µo°Ý] Vlookupªº table_Array ¦p¦ó§ï¬°ÅܼÆÀ³¥Î

½Ð±ÐVBA¥ý¶i

§Ú·Q§Q¥Î°j°é·j´M¤£¦P¤u§@ªíªºTable(¦ý¬O¦P¤@¦ì¸m¤Î¤j¤p)
¦]¦¹·Q±N¤U¦C¦¡¤l¤¤ªºSheet2!R1C10:R1C11§ï¬°ÅܼƨϥνбÐÀ³¸Ó¦p¦ó­×§ï


ÁÂÁÂ

   ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Sheet2!R1C10:R1C11,2,FALSE)"

  1. Sub test()
  2. x = Sheet1.[a1].Value
  3. ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Sheet" & x & "!R1C10:R1C11,2,FALSE)"
  4. End Sub
½Æ»s¥N½X
¦^´_ 1# jk5451280

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD