- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 10
- ÂI¦W
- 0
- §@·~¨t²Î
- winndows
- ³nÅ骩¥»
- win7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-20
- ³Ì«áµn¿ý
- 2013-6-26
|
¦^´_ 13# GBKEE
¦^´_ 16# c_c_lai
·PÁ±jªÌª©¤j̤£§[ªº«ü¾É ì¨ÓDDE¬O³o¼Ë®É¶¡¤~µLªk±µÄò
¨º·Q½Ð±Ðª©¤jÌ Y´úÃÑDDEªº®É¶¡ ¬°©P¤@¦Ü©P¤» 9:00PM-¹j¤éªº2:00AM
§Ú¬O¤£¬On±Nµ{¦¡05¦æ§ï¦¨ If Weekday(Date, vbMonday) > 6 Or Time < #9:00:00 PM# Or Time > #2:00:00 AM# Then Exit Sub '«DÀç·~¤é ©Î «DÀç·~®É¶¡
µM«á31¦æªº§ï¦¨ If Weekday(Date, vbMonday) <= 6 Then Range([C8], [E8].End(xlDown)).Clear 'Àç·~¤é
¥Ñ5§ï¦¨6¬O«ü§«ô¤@¦Ü¤»ªº·N«ä¶Ü? ¨º®É¶¡ªº³¡¤À³o¼Ë§ï¬O¹ïªº¶Ü?
³Â·Ð¦U¦ì¤j¤j̸Ѵb¤F ÁÂÁ±zÌ~ |
|