c_c_lai

¦^´_ 7# v03586
Q3 ¬O³o¼Ë»ò¡H

¤U¸ü (173.44 KB)

2016-8-1 09:51

c_c_lai

¦^´_ 7# v03586

¤U¸ü (208.59 KB)

2016-8-1 13:03

¤U¸ü (219.36 KB)

2016-8-1 13:03

c_c_lai

¦^´_ 11# v03586
¸Õ¸Õ¬Ý¡I
¤H­û¤H¤O¦^³øªí.rar (457.29 KB)

¤U¸ü¦¸¼Æ: 20

2016-8-1 13:10

c_c_lai

¦^´_ 13# v03586
§A­n¥ý¦Û¤v¸Õ¼g¤~¦æ°Ú¡I
³£¼g§¹¤F¹ï§A¬O¨SÀ°§Uªº¡C
­ì¥ý§A¼gªº»yªk§Ú³£¤@¤@­×¥¿¹L¡A
§A¥i±q¤¤¤F¸Ñ¤§«e¤§«áªº²§°Ê¦³¦ó¤£¦P¡H
¦p¦¹§A¤~·|¾Ç¨ìªF¦è¡C
§Ú¤w¸g§â¸û¤£©ö³B¸Ìªº³¡¤À¸Ñ¨M±¼¤F¡A
§A¥ý¸ÕµÛ¦Û¦æ¼¶¼g¡A§Ú¦³ªÅ¤]·|À°§A¯d¯«ªº¡C

c_c_lai

¦^´_ 15# v03586
°Ñ¦Ò¡I  (¦Ü 3.5 ªº«e¥b³¡)
¬Ý¬Ý Sub overTime() ¬O¤£¬O§Aªº·Qªk¡A
½T»{§ó·s·~¤w§¹¦¨ (§A¼gªº¤]¤£¿ù)¡A ¥[ªo¡I
PS §Ú§â©Ò¦³ª«¥ó¦WºÙ§ï¦¨¹ï·Óªº¤¤¤å¦WºÙ
      ¦p¦¹¤è«K¾ã­Óµ{¦¡ªºÂsÄý»PÁA¸Ñ¡C
¤H­û¤H¤O¦^³øªí.rar (459.97 KB)

¤U¸ü¦¸¼Æ: 5

2016-8-2 08:17

¤U¸ü (30.79 KB)

2016-8-2 08:30

c_c_lai

¦^´_ 18# v03586
¸Õ¸Õ¬Ý¡I
¤H­û¤H¤O¦^³øªí.rar (397.63 KB)

¤U¸ü¦¸¼Æ: 5

2016-8-3 21:04

±µ¤U¨Ó§AÀ³¸Ó¥i¥H¤W¤â¤F¡A#18 ¤£©úÁA³B²z²Ó¸`¡H
(Overtime ±o¥[Á`¬O­n­pºâ¦b¡y¤H­û¦^³ø¡z­¶­±ªºC65Äæ¦ì)
©ú¤é§Ú­n¨ìªL¤fªø©°Àˬd²´·ú¡A
§A¦Û¤v¦A¦n¦n¸ÉÀð§a¡I

c_c_lai

¦^´_ 17# v03586
°w¹ï "A2Äæ±±¨î¤ë¥÷?  ©T©wHÄæ«á­±·|¦]¬°¤ë¥÷§ïÅÜ, ¬P´Á¤]§óµÛ§ïÅÜ"
°µ¤F­×¥¿ (¼W¦C chgMonth())¡C¦b UserForm_Initialize() ¶¥¬q«K°µ¤F§PÂ_¡C
±µ¤U¨Ó´N¬Ý§A¤F¡I¥[ªo¡I
§Ú­n·Ç³Æ´NÂå¤F¡C
¤H­û¤H¤O¦^³øªí.rar (400.7 KB)

¤U¸ü¦¸¼Æ: 12

2016-8-4 07:05

c_c_lai

¦^´_ 33# GBKEE
¦b Excel 2010 Àô¹Ò¤U´ú¸Õ:

¤U¸ü (10.87 KB)

2016-8-12 18:38

c_c_lai

¦^´_ 36# v03586
§A§â
    Rng.Offset(2, -4).Resize(3).Select
§ï¦¨³Æµù«¬ºA¡F §Y
    '  Rng.Offset(2, -4).Resize(3).Select
µM«áÀx¦s«á¡A¦A¸Õ¸Õ¬Ý¡I

P.S.¡G
Rng.Offset(2, -4).Resize(3).Select ¶Ç¦^
<µLªk¨ú±oÃþ§O Range ªº Select ÄÝ©Ê>

c_c_lai

¦^´_ 38# v03586
GBKEE ª©¤j  «üªº¬O¡G

¤U¸ü (13.38 KB)

2016-8-15 07:40