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

[µo°Ý] ¨ç¼Æ¨Ï¥Î­þºØ¤ñ¸û§Ö

[µo°Ý] ¨ç¼Æ¨Ï¥Î­þºØ¤ñ¸û§Ö

½Ð°Ý¦U¦ì¤j¤j

§Ú³Ìªñ±`§â¨ç¼Æ¥[¤JVBA»yªk¤¤

¥Ø«e§Ú°µªk¦³¨âºØ¼gªk

1.  .Range("B2").FormulaR1C1 =...... ³oºØ°µªk(¥D­n¬O¥Î¿ý»s¥¨¶°¾Ç¨Óªº «¢«¢)
2.  Application.VLookup(.....)     

²Ä1ºØ¦n¹³´N¸òª½±µ¦b¤u§@ªí¾Þ§@¨ç¼Æ¤@¼Ë¡A·|¦³¤½¦¡¦s¦b
²Ä2ºØµ²ªG¬O¤@¼Ë¡A¦ýª½±µ¬O­È§a?
(§Ú¥Î¤èªk1¸I¤W¤jµ§¸ê®Æ¡A·|¥u°µ²Ä¤@­ÓÀx¦s®æ¡A¦A¥Îfilldownªº¤è¦¡¤U©Ô¡C¤èªk2§Ú¬O·|¥ÎFOR°j°é¥Ñ¤W©¹¤U¶])
¤£ª¾¥H¤W³o¨âºØ¤è¦¡­þ­Ó¤ñ¸û§Ö³t¡A¾A¦X¤jµ§¸ê®Æ¨Ï¥Î

ÁÙ¬O¥t¦³¨ä¥L¤è¦¡¥i¥H¾Þ§@

³Â·Ð¦U¦ì¤j¤j

ÁÂÁ   :   )
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

¥»©«³Ì«á¥Ñ kimbal ©ó 2014-1-29 19:43 ½s¿è

¥i§_´£¨Ñ¤@¤U1 «á­±ªº¤½¦¡?
.Range("B2").FormulaR1C1 =...

½s¿è:
¥i§_´£¨Ñ¤@¤U¨â­Ó¤èªkªº§¹¾ã¥y¤l/XLS?
¬Ý¾ã­Ó°t·f·|¤ñ¸û·Ç½T
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 2# kimbal

§Ú¤]¤£ª¾µ{¦¡½X®t²§¤j¤£¤j

¥D­nÀ³¸Ó¬O¤ñ¸û¥ÎApplication ©M Formulaªº®t²§§a????

Formulaªº°µªk(¥ý¥Î²Ä¤@Äæ¡A¦AFillDown)
Range("I2").FormulaR1C1 = "=VLOOKUP(LEFT(RC[-5],2),other!C[1]:C[2],2,0)"
Range("I2:I" & material_rows).FillDown

Applicationªº°µªk(¥ÎFor°j°é¤@­Ó­Ó¶])
Application.VLookup(.Range("E" & i), Workbooks(fs).Worksheets(1).Range("E:AE"), 27, 0)

¬Ý°_¨Ó¬O¤W­±ªº°µªk¤ñ¸û§Ö¶Ü???

¨þ¨þ  §Ú¤]¤£²M·¡

µ¹¤j¤j°Ñ¦Ò¬Ý¬Ý

ÁÂÁÂ :  )
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD