5457001E01¡A³o¦b¥ÎVBA¦Û°Ê¤ñ¹ï±ø¥ó¼´¥XÈ«áÅܦ¨546E+07¡A³oVBAn¦p¦ó×¥¿©O?
- ©«¤l
- 228
- ¥DÃD
- 62
- ºëµØ
- 0
- ¿n¤À
- 364
- ÂI¦W
- 17
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2007 & 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-5
- ³Ì«áµn¿ý
- 2024-3-12
|
5457001E01¡A³o¦b¥ÎVBA¦Û°Ê¤ñ¹ï±ø¥ó¼´¥XÈ«áÅܦ¨546E+07¡A³oVBAn¦p¦ó×¥¿©O?
5457001E01¡A³o¦b¥ÎVBA¦Û°Ê¤ñ¹ï±ø¥ó¼´¥XÈ«áÅܦ¨546E+07¡A³oVBAn¦p¦ó×¥¿¤~¯à¦Û°Ê¼´¥X¥¿½TªºÈ©O?
²£«~¬d¸ß¨t²Înv.3.0.rar (75.88 KB)
|
|
|
|
|
|
|
- ©«¤l
- 228
- ¥DÃD
- 62
- ºëµØ
- 0
- ¿n¤À
- 364
- ÂI¦W
- 17
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2007 & 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-5
- ³Ì«áµn¿ý
- 2024-3-12
|
¦^´_ 2# s13030029
§Ú®æ¦¡¦Û¤v§ï³o¼Ë³o¤@µ§§ìªº¨ì¡A¦ý¨ä¥Lªº´N¤£½T©w¤F
Moule5 ¸Ì±¥[¤J³o¨Ç
'¥H¤U¬°±NOE No E+®æ¦¡§ï¦¨E
ActiveWindow.ScrollRow = 2
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 4
ActiveWindow.ScrollRow = 5
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 8
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 13
ActiveWindow.ScrollRow = 16
ActiveWindow.ScrollRow = 18
ActiveWindow.ScrollRow = 21
ActiveWindow.ScrollRow = 23
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 29
ActiveWindow.ScrollRow = 32
ActiveWindow.ScrollRow = 36
ActiveWindow.ScrollRow = 40
ActiveWindow.ScrollRow = 45
ActiveWindow.ScrollRow = 50
ActiveWindow.ScrollRow = 54
ActiveWindow.ScrollRow = 59
ActiveWindow.ScrollRow = 64
ActiveWindow.ScrollRow = 68
ActiveWindow.ScrollRow = 72
ActiveWindow.ScrollRow = 75
ActiveWindow.ScrollRow = 78
ActiveWindow.ScrollRow = 81
ActiveWindow.ScrollRow = 85
ActiveWindow.ScrollRow = 87
ActiveWindow.ScrollRow = 89
ActiveWindow.ScrollRow = 92
ActiveWindow.ScrollRow = 94
ActiveWindow.ScrollRow = 97
ActiveWindow.ScrollRow = 99
ActiveWindow.ScrollRow = 102
ActiveWindow.ScrollRow = 104
ActiveWindow.ScrollRow = 107
ActiveWindow.ScrollRow = 110
ActiveWindow.ScrollRow = 113
ActiveWindow.ScrollRow = 116
ActiveWindow.ScrollRow = 118
ActiveWindow.ScrollRow = 120
ActiveWindow.ScrollRow = 122
ActiveWindow.ScrollRow = 123
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 125
ActiveWindow.ScrollRow = 126
ActiveWindow.ScrollRow = 127
ActiveWindow.ScrollRow = 128
ActiveWindow.ScrollRow = 129
ActiveWindow.ScrollRow = 130
ActiveWindow.ScrollRow = 131
ActiveWindow.ScrollRow = 132
ActiveWindow.ScrollRow = 133
ActiveWindow.ScrollRow = 134
Range("F2:F151").Select
ActiveWindow.ScrollRow = 133
ActiveWindow.ScrollRow = 132
ActiveWindow.ScrollRow = 130
ActiveWindow.ScrollRow = 129
ActiveWindow.ScrollRow = 126
ActiveWindow.ScrollRow = 121
ActiveWindow.ScrollRow = 117
ActiveWindow.ScrollRow = 112
ActiveWindow.ScrollRow = 108
ActiveWindow.ScrollRow = 102
ActiveWindow.ScrollRow = 94
ActiveWindow.ScrollRow = 86
ActiveWindow.ScrollRow = 80
ActiveWindow.ScrollRow = 74
ActiveWindow.ScrollRow = 69
ActiveWindow.ScrollRow = 65
ActiveWindow.ScrollRow = 61
ActiveWindow.ScrollRow = 57
ActiveWindow.ScrollRow = 53
ActiveWindow.ScrollRow = 48
ActiveWindow.ScrollRow = 45
ActiveWindow.ScrollRow = 41
ActiveWindow.ScrollRow = 37
ActiveWindow.ScrollRow = 34
ActiveWindow.ScrollRow = 30
ActiveWindow.ScrollRow = 27
ActiveWindow.ScrollRow = 23
ActiveWindow.ScrollRow = 20
ActiveWindow.ScrollRow = 17
ActiveWindow.ScrollRow = 15
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 8
ActiveWindow.ScrollRow = 7
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 5
ActiveWindow.ScrollRow = 4
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 1
Range("F2:F151,O2").Select
Range("O2").Activate
ActiveWindow.ScrollRow = 2
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 4
ActiveWindow.ScrollRow = 5
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 7
ActiveWindow.ScrollRow = 8
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 11
ActiveWindow.ScrollRow = 13
ActiveWindow.ScrollRow = 15
ActiveWindow.ScrollRow = 17
ActiveWindow.ScrollRow = 20
ActiveWindow.ScrollRow = 23
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 28
ActiveWindow.ScrollRow = 31
ActiveWindow.ScrollRow = 34
ActiveWindow.ScrollRow = 36
ActiveWindow.ScrollRow = 39
ActiveWindow.ScrollRow = 42
ActiveWindow.ScrollRow = 46
ActiveWindow.ScrollRow = 50
ActiveWindow.ScrollRow = 55
ActiveWindow.ScrollRow = 60
ActiveWindow.ScrollRow = 66
ActiveWindow.ScrollRow = 72
ActiveWindow.ScrollRow = 76
ActiveWindow.ScrollRow = 80
ActiveWindow.ScrollRow = 84
ActiveWindow.ScrollRow = 87
ActiveWindow.ScrollRow = 89
ActiveWindow.ScrollRow = 91
ActiveWindow.ScrollRow = 93
ActiveWindow.ScrollRow = 95
ActiveWindow.ScrollRow = 97
ActiveWindow.ScrollRow = 99
ActiveWindow.ScrollRow = 102
ActiveWindow.ScrollRow = 104
ActiveWindow.ScrollRow = 107
ActiveWindow.ScrollRow = 109
ActiveWindow.ScrollRow = 112
ActiveWindow.ScrollRow = 114
ActiveWindow.ScrollRow = 117
ActiveWindow.ScrollRow = 120
ActiveWindow.ScrollRow = 121
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 126
ActiveWindow.ScrollRow = 127
ActiveWindow.ScrollRow = 129
ActiveWindow.ScrollRow = 131
ActiveWindow.ScrollRow = 133
ActiveWindow.ScrollRow = 134
Range("F2:F151,O2:O151").Select
Range("O2").Activate
Selection.NumberFormatLocal = "0??0#!E01" '³o¤@¦æ¥i¥HÅýE§ìªº¨ì |
|
|
|
|
|
|
- ©«¤l
- 2798
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2854
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-3-27
|
±NFÄæ³]¬°[¤å¦r]®æ¦¡, «·s¿é¤J5457001E01 |
|
|
|
|
|
|
- ©«¤l
- 228
- ¥DÃD
- 62
- ºëµØ
- 0
- ¿n¤À
- 364
- ÂI¦W
- 17
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2007 & 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-5
- ³Ì«áµn¿ý
- 2024-3-12
|
¦^´_ 4# ã´£³¡ªL
ã¤j¨Á¥D±z¦n¡G
§Úè観·Ó±z»¡ªº¸Õ¹L¡A¦ý¤´µM¤£¦æ¡A¤ñ¹ï«áµ²ªG¬° 5.46E+07 ¡A¦ýÀx¦s®æ¹ê»Ú¬O5470010¡A´Nı±o«Ü©_©Ç¡C
§Ú¤]¤£½T©w¬O¤£¬Oª©¥»ªº°ÝÃD¡A§Ú¬OExcel 2007¦~ª©¡C
¥t¥~³oºØ¸Ì±³£¬O¼Æ¦r¥u¦³¤@½X¬OE©ñ¦b˼ƲÄ3©Î4½X¦n¹³´N·|¦³³oºØ°ÝÃD¡C
ÁÙ¬O¥i¥H½Ð°Ý¬°¤°»ò³oÓÀÉ®×¼´¥Xªºµ²ªG´N¥i¥H²£¥Í¥¿½Tªºµ²ªG©O?
¦pªGn§ïVBA µ{¦¡½X¡An¦p¦ó§ï¨ì1FªºÀɮפ¤©O?
·Ð½Ð¤£§[½ç±Ð¡AÁÂÁ¡C
VBA ¿é¤J§¹¾ã¦r¦ê+¼Æ¦r¼´¥X¸ê®Æ®w¸ê®Æ.rar (16.71 KB)
|
|
|
|
|
|
|
- ©«¤l
- 2798
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2854
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-3-27
|
MsgBox [Sheet1!B18] & " " & [Sheet2!B9]
¨âÓ¤@¼Ëªº,
¼´¸ê®Æ«e, n¥ý±NÀx¦s®æ³]¬°¤å¦r®æ¦¡~~ |
|
|
|
|
|
|
- ©«¤l
- 228
- ¥DÃD
- 62
- ºëµØ
- 0
- ¿n¤À
- 364
- ÂI¦W
- 17
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2007 & 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-5
- ³Ì«áµn¿ý
- 2024-3-12
|
¦^´_ 6# ã´£³¡ªL
ª©¥Dã¤j±z¦n¡G
§Ú¦³·Ó±z»¡ªº¸Õ¹L¡A¦ý¤´µM¤£¦æ¡A¤ñ¹ï«áµ²ªG¬° 5.46E+07 (¦p¹Ï1) ¡A¦ýÀx¦s®æ¹ê»Ú¬O5470010 (¦p¹Ï2)(³o¬OÂà´«¬°¤å¦r«á´NÅܦ¨³o¼Ë¤Ö¤FE«á±´X½X)
¤£¦n·N«ä¡A¤@ª½³Â·Ð±z¡C
|
|
|
|
|
|
|
- ©«¤l
- 82
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 115
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-4-18
|
¥»©«³Ì«á¥Ñ mistery ©ó 2019-6-6 18:52 ½s¿è
³]©w¸Ó¿ï¨ú½d³ò¬°¤å¦r®æ¦¡ --> Selection.NumberFormatLocal =@
©Î¬O¨úÈ·í¤U´Nµ¹¤© ¤å¦r®æ¦¡ --> Cstr (¨ú¦^ªºÈ ) |
|
|
|
|
|
|
- ©«¤l
- 228
- ¥DÃD
- 62
- ºëµØ
- 0
- ¿n¤À
- 364
- ÂI¦W
- 17
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2007 & 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-5
- ³Ì«áµn¿ý
- 2024-3-12
|
¦^´_ 8# mistery
Selection.NumberFormatLocal = " @ "
©Î¥H¤U
Selection.NumberFormatLocal = Chr(64)
³o2Ó³£¸Õ¹L¤£¦æ!! |
|
|
|
|
|
|
- ©«¤l
- 406
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 453
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-2-7
- ³Ì«áµn¿ý
- 2021-7-31
|
¥»©«³Ì«á¥Ñ n7822123 ©ó 2019-6-6 22:40 ½s¿è
¦^´_ 9# jeffrey628litw
§Ú¦b§Aªºµ{¦¡³Ì¤U±¡A˼ƲÄ2¦C¥[¤J¥H¤Uµ{¦¡¡A°ÝÃD´N¸Ñ¨M¤F!
Columns("F:F").NumberFormatLocal = "@"
¦b°õ¦æ¤¤§Aªºµ{¦¡¦³¤@¬qµ{¦¡¬O°µ¶K¤Wªº°Ê§@¡AÀ³¸Ó¦³¶K¨ì§O®æªº®æ¦¡¡A
©Ò¥H°õ¦æ¹Lµ{¤¤¡A¤~·|Åܦ¨¬ì¾Ç°O¸¹¡A¥un³Ì«á´«¦¨¤å¦r´N¥i¥H¤F!
²£«~¬d¸ß¨t²Înv.3.0.rar (73.86 KB)
|
|
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U
|
|
|
|
|
- ©«¤l
- 228
- ¥DÃD
- 62
- ºëµØ
- 0
- ¿n¤À
- 364
- ÂI¦W
- 17
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2007 & 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-5
- ³Ì«áµn¿ý
- 2024-3-12
|
¦^´_ 10# n7822123
n7822123 ¤j±z¦n¡G
³o³¡¤À¦³¸Ñ¨M ®æ¦¡ªº°ÝÃD¡A¤£¹L¥X¨Óªºµ²ªG¤´µM¤£¥¿½T¡A5457001E01 ¤´µM·|Åܦ¨³Ñ¤U 54571010¡C |
|
|
|
|
|
|