- ©«¤l
- 60
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 93
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- Windows 7
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2014-9-8
- ³Ì«áµn¿ý
- 2020-4-15
|
¦^´_ 2# luhpro
¤j¤j±z¦n §Ú·Q½Ð°Ý¤@¤U ¦pªG§Ú·Q§å¦¸×§ï¤u§@ªí Sheets.Add(after:=Sheets(Sheets.Count))³oÓ³¡¥÷¬O§_n§ó§ï¦¨¬YÓ¨ç¼Æ??ÁÙ¬O©ÎªÌ §Ú¥i¥H§ì¨ìAÄ檺¶µ¥ØÓ¼Æ
·í§Ú¥h§ìAÄ檺¶µ¥ØÓ¼Æ ·|Åܦ¨ ¼Æ¦r¥i¥H§ì ¦ý¦pªG¬O¦r¦ê§ì¤£¤F ³o¦³¨ä¥L¸Ñ¨M¤è¦¡¶Ü ³Â·Ð¤F ·PÁÂ
Worksheets(1).Range("A:A").Select
RowCounts = Application.Count(Selection)
Dim lRow&
lRow = 1
Do While Cells(lRow, 1) <> ""
With Sheets.Add(after:=Sheets(Sheets.Count))
.Name = Sheets(1).Cells(lRow, 1)
lRow = lRow + 1
End With
Loop |
|