- ©«¤l
- 522
- ¥DÃD
- 36
- ºëµØ
- 1
- ¿n¤À
- 603
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp sp3
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-13
- ³Ì«áµn¿ý
- 2021-7-11
|
¥»©«³Ì«á¥Ñ yen956 ©ó 2015-11-25 19:59 ½s¿è
ÁÙ¬O㪩¤jªº¤½¦¡§Q®`!!
¥Ñ¥ª¦Ü¥k¨Ì§Ç¥þ¨ú¥X¡G- Private Sub CommandButton1_Click()
- Dim I As Integer, J As Integer
- Dim Col1 As Integer, Num As Integer
- [B:H] = ""
- For I = 1 To [A65536].End(xlUp).Row
- For J = 1 To [J1].End(xlDown).Row
- Num = InStr(Cells(I, 1), Cells(J, 10))
- If Num > 0 Then
- Cells(J, 11) = Num
- Else
- Cells(J, 11) = 10000
- End If
- Next
- [J:K].Sort Key1:=Range("K1"), Order1:=xlAscending, Header:=xlNo
- Col1 = 2
- For J = 1 To [J1].End(xlDown).Row
- If Cells(J, 11) < 9999 Then
- Cells(I, Col1) = Cells(J, 10)
- Col1 = Col1 + 1
- End If
- Next
- Next
- [K:K] = ""
- End Sub
½Æ»s¥N½X
|
|