- ©«¤l
- 66
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-10-1
- ³Ì«áµn¿ý
- 2018-6-26
|
¸ê®Æ¸m´«
¦U¦ì¹F¤H¤S¦³°ÝÃD¤F,·Ð½ÐÀ°¦£¤@¤U
°ÝÃD¦p¤U
¤u§@ªí1
A
1 1-36
2 2-37
3 3-39
¤u§@ªí2
A
1 1-39
2 3-40
·Q§â¤u§@ªí1ªºA3 3-39´«¦¨¤u§@ªí¤¤ªºA2ªº3-40
µ{¦¡¦p¤U:
N = Worksheets("¤u§@ªí3").Cells(Rows.Count, "a").End(xlUp).Row
k4 = Worksheets("¤u§@ªí3").Cells(N, 1)
P = Worksheets("¤u§@ªí1").Cells(Rows.Count, "a").End(xlUp).Row
k5 = Worksheets("¤u§@ªí1").Range("A2:A" & P).Find(What:=k4, LookAt:=xlPart)
K5=K4
¦ý¬O«ç¼Ëªº¨Sªk¦¨¥\.½Ð°Ý¿ù¦bþ¸Ì
ÁÂÁÂ!! |
|