½Ð±Ð for Each ..... Next ¥Îªk
- ©«¤l
- 12
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-30
- ³Ì«áµn¿ý
- 2013-6-4
|
½Ð±Ð for Each ..... Next ¥Îªk
¥»©«³Ì«á¥Ñ JOSH ©ó 2012-11-27 15:40 ½s¿è
Dear ¦U¦ì¤j¤j
½Ð°Ý¤U¦CVBAn«ç»òÅý¥L°±¤î¦b³Ì«á¤@ÓSheet¡A¤£·|¥X²{¿ù»~°T®§!!
§R¨ì³Ì«á¤@Ósheet·|¥X²{µøµ¡¡y³Ì«á¤@Ó¤u§@ªí¡z
ÁÂÁ«ü±Ð
'======================================
Sub Macro1()
Dim mysheet As Worksheet
For Each mysheet In Worksheets
Application.DisplayAlerts = False
mysheet.Delete
Application.DisplayAlerts = True
Next
End Sub |
|
|
|
|
|
|
- ©«¤l
- 94
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 114
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-10-17
- ³Ì«áµn¿ý
- 2014-1-3
|
¦³°ÝÃD¦Aµo°Ý§a!@@- Sub Macro1()
- [color=Red]On Error GoTo restart[/color]
- Dim mysheet As Worksheet
- For Each mysheet In Worksheets
- Application.DisplayAlerts = False
- mysheet.Delete
- Application.DisplayAlerts = True
- Next
- [color=Red]restart:[/color]
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-30
- ³Ì«áµn¿ý
- 2013-6-4
|
¦^´_ 2# die78325
¤j¤j~ »yªk¿ù»~C
|
|
|
|
|
|
|
- ©«¤l
- 94
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 114
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-10-17
- ³Ì«áµn¿ý
- 2014-1-3
|
¦^´_ 3# JOSH
COLO ³o¨Ç¨Æºô¶¤£¤p¤ß¥X²{ªº §R±¼§Y¥i@@"
GB¤j¤j¤w¦^´_±z³Ì¦nªºµª®×@@ |
|
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-30
- ³Ì«áµn¿ý
- 2013-6-4
|
¦^´_ 5# die78325
¤F¸Ñ~~
ÁÂÁÂÅo |
|
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-30
- ³Ì«áµn¿ý
- 2013-6-4
|
¦^´_ 4# GBKEE
ª©¤j~~
ÁÂÁ§Aªº«ü¾É
¨ü¯q¨}¦h
ÁÂÁÂ |
|
|
|
|
|
|