c_c_lai

¦^´_ 46# ziv976688
³Ìªñ¦]®a¨ÆÁc¦£¡A¬G¥u¯à©âªÅ­×¥¿¡F
ªþ¤W­×¥¿ (ÅÞ¿è) «á¤§°õ¦æµ²ªG¡A³Â·ÐÀˬd¬Ý¬Ý
¬O§_¥¿½T¡H

¤U¸ü (97.31 KB)

2017-1-25 07:23

1. -------------------------------------------
   
2. DGroup(1) :  : Variant(1 to 4)
   
3. DGroup(1,1) = "22" : Variant/String
   
4. DGroup(1,2) = "20" : Variant/String
   
5. DGroup(1,3) = "2" : Variant/String
   
6. DGroup(1,4) = "1" : Variant/String
   
7. -------------------------------------------
   
8. NCnt :  : Variant/String(0 to 1)
   
9. NCnt(0) = "2" : String
   
10. NCnt(1) = "3" : String
    
11. ----------------------------------
    
12. ²Ä 1 ­Ó Ncount = 2 ²Õ¦X¦¸¼Æ
    
13. ----------------------------------
    
14. ²Ä 1 ­Ó A ²Õ¦X
    
15. °_©l¦C = 12
    
16. ²×¤î¦C = 27
    
17. ´Á  ¶Z = 6
    
18. ´Á  ¼Æ = 21
    
19. ²Ä¤@²Õ = 01
    
20. ²Ä¤G²Õ = 02
    
21. ----------------------------------
    
22. ²Ä 2 ­Ó A ²Õ¦X
    
23. °_©l¦C = 8
    
24. ²×¤î¦C = 23
    
25. ´Á  ¶Z = 6
    
26. ´Á  ¼Æ = 17
    
27. ²Ä¤@²Õ = 01
    
28. ²Ä¤G²Õ = 02
    
29. ----------------------------------
    
30. ²Ä 1 ­Ó B ²Õ¦X
    
31. °_©l¦C = 11
    
32. ²×¤î¦C = 26
    
33. ´Á  ¶Z = 8
    
34. ´Á  ¼Æ = 18
    
35. ²Ä¤­²Õ = 30
    
36. ----------------------------------
    
37. ²Ä 2 ­Ó B ²Õ¦X
    
38. °_©l¦C = 9
    
39. ²×¤î¦C = 24
    
40. ´Á  ¶Z = 8
    
41. ´Á  ¼Æ = 16
    
42. ²Ä¤­²Õ = 30
    
43. ----------------------------------
    
44. ²Ä 1 ­Ó C ²Õ¦X
    
45. °_©l¦C = 12
    
46. ²×¤î¦C = 27
    
47. ´Á  ¶Z = 6
    
48. ´Á  ¼Æ = 21
    
49. ²Ä¤@²Õ = 01
    
50. ²Ä¤G²Õ = 02
    
51. ´Á  ¼Æ = 18
    
52. ²Ä¤­²Õ = 30
    
53. ----------------------------------
    
54. ²Ä 2 ­Ó C ²Õ¦X
    
55. °_©l¦C = 8
    
56. ²×¤î¦C = 23
    
57. ´Á  ¶Z = 6
    
58. ´Á  ¼Æ = 17
    
59. ²Ä¤@²Õ = 01
    
60. ²Ä¤G²Õ = 02
    
61. ´Á  ¼Æ = 16
    
62. ²Ä¤­²Õ = 30
    
63. ----------------------------------
    
64. ²Ä 1 ­Ó Ncount = 3 ²Õ¦X¦¸¼Æ
    
65. ----------------------------------
    
66. ²Ä 1 ­Ó A ²Õ¦X
    
67. °_©l¦C = 12
    
68. ²×¤î¦C = 27
    
69. ´Á  ¶Z = 6
    
70. ´Á  ¼Æ = 21
    
71. ²Ä¤@²Õ = 01
    
72. ²Ä¤G²Õ = 02
    
73. ----------------------------------
    
74. ²Ä 2 ­Ó A ²Õ¦X
    
75. °_©l¦C = 8
    
76. ²×¤î¦C = 23
    
77. ´Á  ¶Z = 6
    
78. ´Á  ¼Æ = 17
    
79. ²Ä¤@²Õ = 01
    
80. ²Ä¤G²Õ = 02
    
81. ----------------------------------
    
82. ²Ä 3 ­Ó A ²Õ¦X
    
83. °_©l¦C = 5
    
84. ²×¤î¦C = 20
    
85. ´Á  ¶Z = 6
    
86. ´Á  ¼Æ = 14
    
87. ²Ä¤@²Õ = 01
    
88. ²Ä¤G²Õ = 02
    
89. ----------------------------------
    
90. ²Ä 1 ­Ó B ²Õ¦X
    
91. °_©l¦C = 12
    
92. ²×¤î¦C = 27
    
93. ´Á  ¶Z = 8
    
94. ´Á  ¼Æ = 19
    
95. ²Ä¤T²Õ = 17
    
96. ----------------------------------
    
97. ²Ä 2 ­Ó B ²Õ¦X
    
98. °_©l¦C = 9
    
99. ²×¤î¦C = 24
    
100. ´Á  ¶Z = 8
     
101. ´Á  ¼Æ = 16
     
102. ²Ä¤T²Õ = 17
     
103. ----------------------------------
     
104. ²Ä 3 ­Ó B ²Õ¦X
     
105. °_©l¦C = 8
     
106. ²×¤î¦C = 23
     
107. ´Á  ¶Z = 8
     
108. ´Á  ¼Æ = 15
     
109. ²Ä¤T²Õ = 17
     
110. ----------------------------------
     
111. ²Ä 1 ­Ó C ²Õ¦X
     
112. °_©l¦C = 12
     
113. ²×¤î¦C = 27
     
114. ´Á  ¶Z = 6
     
115. ´Á  ¼Æ = 21
     
116. ²Ä¤@²Õ = 01
     
117. ²Ä¤G²Õ = 02
     
118. ´Á  ¼Æ = 19
     
119. ²Ä¤T²Õ = 17
     
120. ----------------------------------
     
121. ²Ä 2 ­Ó C ²Õ¦X
     
122. °_©l¦C = 8
     
123. ²×¤î¦C = 23
     
124. ´Á  ¶Z = 6
     
125. ´Á  ¼Æ = 17
     
126. ²Ä¤@²Õ = 01
     
127. ²Ä¤G²Õ = 02
     
128. ´Á  ¼Æ = 16
     
129. ²Ä¤T²Õ = 17
     
130. ----------------------------------
     
131. ²Ä 3 ­Ó C ²Õ¦X
     
132. °_©l¦C = 5
     
133. ²×¤î¦C = 20
     
134. ´Á  ¶Z = 6
     
135. ´Á  ¼Æ = 14
     
136. ²Ä¤@²Õ = 01
     
137. ²Ä¤G²Õ = 02
     
138. ´Á  ¼Æ = 15
     
139. ²Ä¤T²Õ = 17
     
140. ----------------------------------

½Æ»s¥N½X

c_c_lai

¦^´_ 48# ziv976688
§Ö¹L¦~¤F¡AÁÙ¬O©â®É¶¡±N¥¦»°¥X¨Ó¡C
¤u§@ªí³æ©R¦W '  Sheets(Sheets.Count).Name = ""
§A¨Óµ¹§a¡I

¤U¸ü (68.78 KB)

2017-1-25 17:38

BASE_T-1-B2(MF).rar (37.89 KB)

¤U¸ü¦¸¼Æ: 6

2017-1-25 17:37

c_c_lai

¦^´_ 50# ziv976688
¶}¼úª©(¤ñ¹ïªº°ò·Çª©)©M²Ä1­ÓÅçÃÒ²Õ¦X­«½Æ¤F¡H
»¡¯u®æªº¡A¤£¤ÓÀ´§A»¡ªº "²Õ¦X­«½Æ" ¬O¦b­þ¸Ì¡H
¦p¤U¹Ï¡A¹ï§Ú³o¥~¦æ¤H¨Ó»¡¹ê¦b¬Ý¤£¥X©Ò¥HµM¡C

¤U¸ü (87.85 KB)

2017-1-26 08:08

c_c_lai

¦^´_ 53# ziv976688
¦b #50  ªº¨Ò¤l¡A§A¬O¥Î
      StrRng = "1"
      Nrange = "28" '
      num = "15"
      RrngA = "21-24"
      CrngA = "1-2"
      RrngB = "18-21"
      CrngB = "1-2"
      Order = ""
      Number = "3,11,21-26,43,49"
      Ncount = "2-3"
°µ¸Ñ»¡¡C

¦Ó§Úªº #49 µ{¦¡¤º¡A¬O¥H
      StrRng = "1"
      Nrange = "28" '
      num = "15"
      RrngA = "22"
      CrngA = "2"
      RrngB = "20"
      CrngB = "1"
      Order = ""
      Number = "3,11,21-26,43,49"
      Ncount = "2-3"
¨Ó°õ¦æ´ú¸Õªº¡C½Ð¦A¦¸½T¹ê®Ö¹ï¡C

c_c_lai

¦^´_ 55# ziv976688
¦UÅçÃÒ²Õ¦X¤§³Ì¥½¦C¨S¦³¬Û¦Pªº«ü©w¸¹½X¡A
¤£¬O¥u­n¦³«ü©w¸¹½X´N OK ¤F¶Ü¡H
§A¬O»¡©Ò¦³ªº¦UÅçÃÒ²Õ¦X«ü©w¸¹½X­n¦³¤@²Õ
¬Û¦Pªº«ü©w¸¹½X¡H¥u¦³³o­Ó°ÝÃD¶Ü¡H

c_c_lai

¦^´_ 57# ziv976688
§Úµø¤O¤£¦n (°Ê¹L¶}¤M¤â³N)¡A
§A¦A¸Õ¸Õ¬Ý¬O§_§k¦X»Ý¨D¡H
BASE_T-1-B3(MF).rar (52.47 KB)

¤U¸ü¦¸¼Æ: 5

2017-1-29 08:56

c_c_lai

¦^´_ 55# ziv976688

¤U¸ü (73.57 KB)

2017-1-29 09:48

¤U¸ü (73.88 KB)

2017-1-29 09:48

BASE_T-1-B3(MF).rar (57.99 KB)

¤U¸ü¦¸¼Æ: 5

2017-1-29 09:53

c_c_lai

¦^´_ 60# ziv976688
¨ì¦¹§AÀ³¸Ó¦Û¤v¥i¥H¤W¤â±µÄò¤F¡I
§Úµø¤O¤£¨ÎµLªk¥J²Ó¾\Äý¤§¬G¡C

c_c_lai

¦^´_ 62# ziv976688
¨º´N¥H¥»¼Ó¬°½d¨Ò¡A«e«á¦UÁ|¥X§A·Q­nªº¤T­Ó¨ã¦³
¥Nªí©Ê¥B¬O¥¿½T¦ì¸mªº¹Ïªí   (¦@¤»±i¹Ï¥Ü½d¨Ò)¡F
(§Y 73 ­ÓÀɮפ¤«e¥b³¡»P«á¥b³¡­ÓÁ|¤T­Ó¹ê¨Ò¹Ï«¬)

     StrRng = "1"
      Nrange = "28" '
      num = "15"
      RrngA = "21-24"
      CrngA = "1-2"
      RrngB = "18-21"
      CrngB = "1-2"
      Order = ""
      Number = "3,11,21-26,43,49"
      Ncount = "2-3"

¦p¦¹¤~¯à±oª¾©úÁA§Aªº¯u¥¿ªí¹F»P»Ý¨D¡A
¹Ï«¬¤¤¥ç½Ðµy¥[¸àÄÀ­nª`·N¨Æ¶µ¡A»P»Ý¨D­ì¦]¡C
¤£µM¥ú¦³¹Ïªí»P©Ò¿× (©Ô¥­)¡A ´N¤£ª¾¦ó·N¡H

P,S,   ¤£­n¥Î§Úµ{¦¡¤º©Ò²£¥Íªº¤u§@ªí¤º®e§@¬°½d¨Ò¡F
          ¦Ó¬O¥H§A¤H¤u¼Ò¦¡»s¥Xªº»Ý¨D¤u§@ªí³æ¬°¨Ì¾Ú¡C

          µ{¦¡½X¨Ã«D¤@©w­n¼g¦bThis Workbook¡A
          ¤]¥i©ñ¸m¦b "¼Ò²Õ" ¤ºªº¡C

c_c_lai

¦^´_ 66# ziv976688
¦^´_ 63# Airman
¦A¸Õ¸Õ¬Ý§a¡I
BASE_T-1-R1(MF).rar (45.92 KB)

¤U¸ü¦¸¼Æ: 6

2017-2-3 18:15

·j´M¬Û¦P¼Æ¦rªº²Õ¦Xµ{¦¡¹Lµ{¸Ñ»¡.rar (238.5 KB)

¤U¸ü¦¸¼Æ: 4

2017-2-3 18:15