- ©«¤l
- 705
- ¥DÃD
- 277
- ºëµØ
- 0
- ¿n¤À
- 1008
- ÂI¦W
- 1
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-12-24
|
¦^´_ 10# GBKEE
§Ú¥Ø«e¹q¸£Åܦ^Office XP
§Ú¦bª«¥ó¼Ò²Õ¤¤°õ¦æ¤F
Sub aa()
Range("B1").Select
Range("B1") = "=IF(SUM(--ISNUMBER(FIND(A$1,¦a§}!C$1:C$100)))<ROW(),"""",INDEX(¦a§}!C:C,SMALL(IF(ISNUMBER(FIND(A$1,¦a§}!$C$1:$C$100)),ROW($A$1:$B$100)),ROW())))"
Application.SendKeys "{F2}"
Application.SendKeys "^+~"
End Sub
°õ¦æ«á~¥L¨ÌµM¥X²{~¥²¶·«ü©w·j´M¦r¦ê~¬O¦]¬°§Ú¨Ï¥ÎOffice XPªº°ÝÃD¶Ü? |
|