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

[µo°Ý] VBA Àx¦s®æ±a¤J¤½¦¡°ÝÃD

[µo°Ý] VBA Àx¦s®æ±a¤J¤½¦¡°ÝÃD

½Ð±Ð°ª¤â
¤p§Ì¦Û¤v¼gªºVBA ¦³±a¤½¦¡¨ìÀx¦s®æ¤º
¨ä¤¤¤º®e¦p¤U
Cells(23, 6) = "=IFERROR(VLOOKUP($C23,°ò¥»¸ê®Æ!$B:$S,4,0),"""")"

¦ý¤p§Ì¦³«Ü¦h®æ­n¼g
Cells(23, 6) = "=IFERROR(VLOOKUP($C23,°ò¥»¸ê®Æ!$B:$S,4,0),"""")"
Cells(24, 6) = "=IFERROR(VLOOKUP($C24,°ò¥»¸ê®Æ!$B:$S,4,0),"""")"
Cells(25, 6) = "=IFERROR(VLOOKUP($C25,°ò¥»¸ê®Æ!$B:$S,4,0),"""")"
.
.
.
.
½Ð°Ý¦³¨S¦³Â²«K¤@ÂIªº¼gªk
¥ÎDo loop¶Ü
ÁÙ¬OFOR NEXT ¼g©O??

¦^´_ 1# fantersy


    ª½±µ½d³òµ¹¥¦´N¦æ¤F¦p¤U:
Range("F23:F30") = "=IFERROR(VLOOKUP($C23,°ò¥»¸ê®Æ!$B:$S,4,0),"""")"

TOP

¦^´_  fantersy


    ª½±µ½d³òµ¹¥¦´N¦æ¤F¦p¤U:
Range("F23:F30") = "=IFERROR(VLOOKUP($C23,°ò¥»¸ê®Æ ...
lpk187 µoªí©ó 2015-4-19 15:55



·PÁÂlpk187 ¤jªº¦^ÂÐ
µ¥·|¨Ó´ú¸Õ¬Ý¬Ý~
·P®¦§A^^

TOP

¦^´_  fantersy


    ª½±µ½d³òµ¹¥¦´N¦æ¤F¦p¤U:
Range("F23:F30") = "=IFERROR(VLOOKUP($C23,°ò¥»¸ê®Æ ...
lpk187 µoªí©ó 2015-4-19 15:55



    ÁÙ¨S¦³´ú~¥u¬O­è·Q¨ì..
¨º¤½¦¡¸ÌªºC23....¤£·|¸òµÛ¸õ...¤£¬O«Ü©Ç¶Ü?

TOP

¦^´_ 4# fantersy


    §A´ú¤F´N·|ª¾¹D¡AC23¤@©w·|¸òµÛÅÜ

TOP

¦^´_  fantersy


    §A´ú¤F´N·|ª¾¹D¡AC23¤@©w·|¸òµÛÅÜ
lpk187 µoªí©ó 2015-4-19 19:38



    ·PÁÂlpk187 ¤j¤j
­è´ú¸Õ§¹¤F..¥i¥H
­ì¨ÓÁÙ¦³³oºØ¼gªk...
§Ú­è¥ÎRange("F23:F30") .Select
µ²ªG¶]¤£¥X¨Ó
«áÁ٥ΤF¤j¤jªºRange("F23:F30")  ¨S¦³¥[¤WSelect ´N¥i¥H¤F
¦Ó¥BÁÙ·|¦Û¤v¶]....
·PÁ¤j¤jªºÀ°¦£^^

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD