ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ®Ú¾Ú"®Æ¸¹Äæ"¬°¨Ì¾Ú,°µ±Æ§Ç

¦^´_ 10# PJChen

§Ú¦³­×§ï¹L¤F  ¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý ¦æ¤£¦æ ·PÁÂ

RR0412.rar (300.22 KB)

TOP

¦^´_ 11# °a¤ªºµ
ºµ¤j¦n,
§Ú±N¥Ø«e¥i¯à·|»Ý­n±Æ§Çªº¤u§@ªí³£©ñ¤J¤@¨Ö´ú¸Õ,¦p¤U:
1) ©Ò¦³¤u§@ªí,±Æ§Çªº¸ê®Æ¤U¥b³¡¤£¥¿½T
2) ¤u§@ªí§ó§ï¹LªíÀY(§âªíÀY½d³ò¥[¤j),±Æ§Ç´N§ó¤£¥¿½T

R0412.rar (393.09 KB)

TOP

¦^´_ 12# PJChen

§ï¦n¤F ¦³ªÅ¦A¬Ý¬Ý¬O¤£¬O§A­nªºµ²ªG ·PÁÂ
R0413.rar (401.45 KB)

TOP

¦^´_ 13# °a¤ªºµ

ºµ¤j¦n,

1) ¦L½LÂIªí...³o­Ó¤u§@ªí§¹¥þµLªk±Æ§Ç,§Ú·Q¬O¦]¬°²Ä¤@Äæ¬OªÅ¥Õ,¦b²Ä¤@Äækey¤J¬Y¨Ç¼Æ¦r«á,´N¥i¥H¥¿±`±Æ§Ç,¤£ª¾³o­Ó¯à°÷§JªA¶Ü?¦pªG¤£¦æ,´N¤£§ïµ{¦¡¤F¡I
2) ¥t¥~,µL·N¤¤µo²{­Y¦bµ{¦¡¤¤«öF5,«hµ{¦¡¤]¤£¯à±Æ§Ç,¦ý«ö"sorting"Áä®É«h¥i±Æ§Ç,¤£ª¾­ì¦]¡H

TOP

¦^´_ 14# PJChen
§Ú¤]¤£ª¾¹D F5 ªº°ÝÃD >"<     ¦³ªÅ¦bÀ°§Ú¸Õ¸Õ¬Ý ÁÙ¦³¨S¦³°ÝÃD ·PÁÂ

R0413_1.rar (402.34 KB)

TOP

¦^´_ 15# °a¤ªºµ
ºµ¤j¦n,
§Ú§âµ{¦¡µy§@­×§ï,¥H«K¶¶À³§Ú¥­¤é¥¿¦¡ÀÉ,µ{¦¡»P°õ¦æ³øªí¬O¤À¶}ªº,¦ý­×§ï«áµ{¦¡´N°±¦b
b = xB.Sheets(a3).[a1].SpecialCells(xlCellTypeConstants, 23).Column
µLªk°õ¦æ,½ÐÀ°¦£¬Ý¬Ý¡I
R0413_1.rar (414.14 KB)

TOP

¦^´_ 16# PJChen

¥i¥H§â­n­×§ïªº ¨BÆJ¼g¥X¨Ó

TOP

¦^´_ 16# PJChen

¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý ¬O¤£¬O§A­nªºµ²ªG ·PÁÂ

R0415.rar (411.68 KB)

TOP

¦^´_ 16# PJChen

³o¬O¦³¥[¤J¦h­Ó¬¡­¶Ã¯´`Àô©M³æ¤@¬¡­¶Ã¯¬Ý­n¥Î­þ¤@­Ó  ¬Ý¬Ý³o¼Ë¦æ¤£¦æ ¤]³\¥i¥H¦s¦¨¼W¯q¶°
0415_1.rar (22.33 KB)

TOP

¦^´_ 19# °a¤ªºµ
ºµ¤j¦n,
¥H¤U°ÝÃD¬O¥Î19¼Óªºµ{¦¡´ú¸Õªº:
1) MsgBox "¿ï¨ú¨Ì¾Ú¸ê®ÆÀɮתº¦ì¸m"
¦]¬°§ÚªºÀÉ®×·|¦³¦h­Ó¤u§@ªí,©Ò¥H°£¤F«ü©w¦ì¸m¥~,ÁÙ¥²¶·­n¥i¥H«ü©w"¨Ì¾Ú"­þ­Ó¤u§@ªí¦WºÙ¨Ó±Æ§Ç
2) «Ý±Æ§ÇªºÀÉ®×,¤£¤@©w»Pµ{¦¡©ñ¦b¦P¤@¥Ø¿ý¤U,¥B¤]¨S¦³¸ß°Ý­n±Æ§Ç­þ­ÓÀÉ,´ú¸Õ®É©ñ¤F2­ÓÀÉ®×,³£·|¥´¶},¦ý¥u±Æ§Ç¨ä¤¤¤@­ÓÀÉ,À³¸Ó­n¦³¿ï¨úÀɮצì¸m¥\¯à¤ñ¸û¤£·|¥X¿ù
3) ³o¸Ì¥i¥H«ü©w­n±Æ¦Cªº¤u§@ªíªº¦ì¸m"¾ã¤ë²Î­p" ©Î "3",
À³¸Ó¬O³æ¤@¤u§@ªí±Æ§Ç,¦ý·|¥X²{¤G¦¸¸ß°Ý,§Ú´ú¸Õ2¦¸¿é¤J¤£¦P¦WºÙ,µ²ªG¥¦¥u·|±Æ²Ä2¦¸¿é¤Jªº¤u§@ªí,³æ­Ó¤u§@ªí±Æ§Ç,À³¸Ó¥u¸ß°Ý¤@¦¸´N¦n
4) ¦h­Ó¤u§@ªí±Æ§Ç,
·|¥X²{1)°_ & 2)¨´ªº¸ß°Ý,µM«á¦A¥X²{¸ß°Ý«ü©w¤u§@ªí¦WºÙ,§Ú±N¥¦¨ú®øor½T©w,¤S·|±qÀY¦A°Ý¤@¦¸,¤~¶}©l°õ¦æ±Æ§Ç,À³¸Ó¥u°Ý°_ & ¨´´N¥i¥H¤F
5) ¦h­Ó¤u§@ªí±Æ§Ç,¨Ò¦p«ü©w±Æ2~8,¦ý¥u·|±Æ2~7
6) ¥t¤@¦¸´ú¸Õ«ü©w±Æ3~20,¨ä²Ä3­Ó¤u§@ªí¦WºÙ¬O1,²Ä20­Ó¤u§@ªí¬O18,¥u±Æ¤F18­Ó,¦n¹³¨C¦¸³£¤£¤Ó¤@¼Ë¡I
7) ÁöµMµ{¦¡¤¤¦³Application.Calculation = xlCalculationManual
¦ý¦n¹³µLªk«Ü§Ö³t±Æ§Ç,¬O¦]¬°±Æ§Ç³£¬O¤ñ¸ûºCªº¶Ü?

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD