¦p¦ó±N"Sheet1"¦WºÙ§ó´«¦¨A-B-C-D
- ©«¤l
- 45
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-8-9
- ³Ì«áµn¿ý
- 2015-4-14
|
¦p¦ó±N"Sheet1"¦WºÙ§ó´«¦¨A-B-C-D
¦p¦ó±N"Sheet1"¦WºÙ§ó´«¦¨A-B-C-D |
|
|
|
|
|
|
- ©«¤l
- 133
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 147
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-9-9
|
¦^´_ 1# yueh0720
¹³³o¼Ë?
Sheets("Sheet1").Name = "A-B-C-D" |
|
|
|
|
|
|
- ©«¤l
- 11
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 120
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-22
- ³Ì«áµn¿ý
- 2011-3-29
|
¬Ý¤£À´«¨ §Aªº"-" ¬O "dash" or "minus" ¤]¤À¤£²M·¡
1.¦pªGA,B,C,D¬O©T©wªº¤å¦r¨º´N¦p¤W¤@¼Ó©Òµª
2.¦pªGA,B,C,D ¬O¥i¸m´«ªº¤å¦r ¨º´Nn¬ÝA,B,C,D«e«á¦³¨S¦³ªÅ®æ ÁÙ¬O¥u¬O¦p§Aªí¤W§âA,B,C,D¸m¤¤¦Ó¤w
3.¦pªGA,B,C,D¬O¼Æ¦r¨º¤S¤£¤@¼Ë
.
.
¨ì©³§Anªº¬Oþ¤@ºØµª®×©O? |
|
|
|
|
|
|
- ©«¤l
- 23
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 97
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °¨¨Ó¦è¨È
- µù¥U®É¶¡
- 2010-8-16
- ³Ì«áµn¿ý
- 2011-1-10
|
1. 将·Æ¹««ü¦V "Sheet1" µM¦Z«ö·Æ¹«¥k键
2. 选择 "rename" (©ö¦W/§ó¦W/§ï¦W/换¦W)
3. 输¤J§Anªº"A-B-C-D" |
|
|
|
|
|
|
- ©«¤l
- 45
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-8-9
- ³Ì«áµn¿ý
- 2015-4-14
|
¬O"dash"
A,B,C,D¬O¥iÅܼƦr©M¤å¦r
¦bA,B,C,DÄæ¦ì¿é¤J§Únªº¼Æ¦r©M¤å¦r«á,"Sheet1" ¦Û°Ê²£¥ÍÅܦ¨A-B-C-D |
|
|
|
|
|
|
- ©«¤l
- 11
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 120
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-22
- ³Ì«áµn¿ý
- 2011-3-29
|
¦^´_ 6# Hsieh
Hsieh¤j¤Ó±j¤F
¦]¬°³Ìªñ¤]¸I¨ìÃþ¦ü°ÝÃD
¤]·Q¶¶«K½Ð±Ð
°²³]Y¬OABCD¬O«e«á¦³ªÅ¥Õ(space)ªº¦r¦ê
n¦p¦ó×¥¿©O?
|
|
|
|
|
|
|
- ©«¤l
- 45
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-8-9
- ³Ì«áµn¿ý
- 2015-4-14
|
¤£¯à¨Ï¥Î£z
1.¦b¥¨¶°¦WºÙ¬Ý¤£¨ì Worksheet_Change(ByVal Target As Range)
2.°õ¦æ«á·|n¨D¿ï¾Ü¥¨¶°¦WºÙ,ÀH·N¿ï¾Ü¤@Ó¥¨¶°¦WºÙ«á°õ¦æ"Sheet1"¨SÅܧó¦¨A-B-C-D |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
«¢«¢¡A¨q¤~¹J¨ì§L¡C
³o¬O¤u§@ªí¨Æ¥ó¡A¤£·|Åã¥Ü¦b¥¨¶°ªí¤¤¡C
§â¥N½X¶K¦b¨Ï¥Î¤u§@ªíªº¼Ò²Õ¡A¤£¬O¦bModule¤¤
¦bb3:b6¦³¿é¤J°Ê§@®É¦Û°Ê¹B¦æ¡I |
|
|
|
|
|
|