- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¥»©«³Ì«á¥Ñ owen06 ©ó 2015-3-3 12:56 ½s¿è
¦^´_ 1# chi830
¦bvba¸Ì´¡¤J·s¼Ò²Õ¡A¶K¤W¤U¦C¤º®e- Sub test()
- Dim MyBook As Workbook, sh As Worksheet
- Set MyBook = ThisWorkbook
- Ans = Application.InputBox("½Ð¿é¤J¤u§@ªí¦WºÙ", "§Ö³t¤Á´«", "")
- For Each sh In MyBook.Sheets
- If sh.Name Like "*" & Ans & "*" Then sh.Select
- Next
- End Sub
½Æ»s¥N½X µM«á¦A¶i¥h¡y¥¨¶°¡z¸Ìªº¡y¿ï¶µ¡z¡A§â¸Ó¥¨¶°³]©w§A¦Û¤v·Qnªº§Ö³tÁä¡A³o¼Ë´N¥i¥H¹F¦¨§A·Qnªº¤è¦¡¤F¡C |
|