- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¥»©«³Ì«á¥Ñ stillfish00 ©ó 2014-2-12 19:49 ½s¿è
¦^´_ 1# bulletin
C :
¬O¦]¬°Àx¦s®æªº¦ì¸m¥i¥H¦³¨âºØªí¥Ü¤èªk¡A¤@ºØ¬O±`¨£ªºA1¼Ë¦¡¡A¤@ºØ¬OR1C1¼Ë¦¡
¨Ï¥ÎFormulaR1C1«ü©w¤½¦¡®É»Ýn¥ÎR1C1¼Ë¦¡
¨Ï¥ÎFormula«ü©w¤½¦¡ ¤~¬O¥ÎA1¼Ë¦¡
¿ù¦b Range("E2").FormulaR1C1 = "=VLOOKUP(R[-1]C,[1101©u³ø.xlsx]ISQ!$A$1:$J$58,2,FALSE)"
D :
§A¨S§ËÀ´¦r¦ê¡A§AnªºÀ³¸Ó¬O³o¼Ë§a...
"=VLOOKUP(""" & Range("E2").value & """,[" & Range("A" & i).Value & "©u³ø.xlsx]ISQ!R1C1:R52C9, 2, FALSE)"
ÂŦâ¬O¤å¦r¦r¦ê¡A¥Nªíªº¬OÂù¤Þ¸¹¤ºªº¤å¦r¡A¤å¦r¦r¦ê¤ºªºÂù¤Þ¸¹n¥Î¨âÓÂù¤Þ¸¹¥N´À
ºñ¦â¬OVBAªº»yªk¡A¨ú¦^Àx¦s®æ¤º®e
µM«á¥Î & §â¦UÓ³¡¤Àµ²¦X°_¨Ó¦¨¬°¤@Ó¦r¦ê |
|