¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-3-26 09:21 ½s¿è
¦^´_ 1# jeremy
³Â·Ð¹w³] ¤u§@ªí¼Æ¬°1Ó
Sub xj()
For xn = 2 To 20 ' ±q²Ä¤GÓ ªºì¦]¬O¤£¥]§t ¥Ø¿ý³oÓ
Sheets.Add After:=Sheets(Sheets.Count)
Sheets("sheet" & xn).Name = Sheet1.Range("a" & xn).Value 'sheet1 ³]©w¬° nÀx¦sªº¦WºÙ
Next xn
End Sub
¯ÊÂI¬O ¦¹µ{¦¡·f°t §PÂ_SHEET ¬O§_¦s¦bªºµ{¦¡¬q
´ú¸Õ.rar (13.01 KB)
|
|