- ©«¤l
- 2798
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2854
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-4-20
|
¦^´_ 5# iceandy6150
°Ý1)
Private Sub CommandButton1_Click()
Dim Arr, TT$, T, xR As Range, xS As Worksheet
Set xS = Sheets("¤u§@ªí3")
Arr = xS.Range(xS.Range("E1"), xS.Range("F65536").End(xlUp))
For Each xR In xS.Range(xS.[A3], xS.[A65536].End(xlUp))
For i = 1 To UBound(Arr)
If Arr(i, 1) <> "" And InStr(xR, Arr(i, 1)) Then TT = TT & "¡B" & Arr(i, 2)
Next i
xR(1, 3) = Mid(TT, 2): TT = ""
Next
End Sub
°Ý2)
n¬Ý§¹¾ãªºµ{¦¡¤~¥i§PÂ_¿ù¦bþ???
======================== |
|