- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-2-26
|
¥»©«³Ì«á¥Ñ lpk187 ©ó 2015-8-21 08:57 ½s¿è
¦^´_ 3# missbb
´`Àô»Ýn¦A¥[¤W¤@ÓÅܼÆ- Sub getSheetName()
- Dim i As Integer
- Dim shtname As Integer
-
- Worksheets("aa").Select
- Range("B1").CurrentRegion.Clear
-
- Range("B1").Select
- n = 1
- For i = 7 To Worksheets.Count
-
- Range("B" & n).Resize(20) = Worksheets(i).Name
- n = n + 20
- Next i
-
- End Sub
½Æ»s¥N½X |
|