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

½Ð°Ý«ç»ò±Æ°£³o­Ó°»¿ù

½Ð°Ý«ç»ò±Æ°£³o­Ó°»¿ù

½Ð°Ý¦]¬°¤½¥q»Ý­n¡A©Ò¥H»Ý­n±N­q³æ®É¶¡¬°­q³æ¤é´Á12ÂI«eªº­q³æ§R°£¡A
§Ú¼g¤F­Ó¥¨¶°¡A¬O¥i¥H°õ¦æ¡A¦ý¬O¡A­Y³o­ÓÀɮפw³Q°õ¦æ«á
¦AÂI¥¨¶°«á¡A´N·|¥X²{°»¿ù¡I
§Ú¦b·Q¬O¦]¬°12ÂI«eªº­q³æ¤w³Q§R°£¡A©Ò¥H¥¦µLªk§P§O¦p¤U°õ¦æ¡A
½Ð°Ý¦³¿ìªk±Æ°£³o­Ó°»¿ù¶Ü¡H

Book3.rar (212.62 KB)

·s¤H¤@ªT

§A¦Û¤v¤w¸g´£¨Ñ¨âºØ¿ï¾Ü¥i¥Î¡G
(1)¼W¥[¤@­Ó®É¶¡¶W¹L12ÂI´N¤£°õ¦æ¥¨¶°ªº§PÂ_¦¡¡C
(2)¼W¥[¤@­ÓÀˬdµL­q³æ¦s¦b´N¤£°õ¦æ¥¨¶°ªº§PÂ_¦¡¡C
(1) or (2) ¦¨¥ß¡A¤£°õ¦æ¥¨¶°¡C
«Ü©êºp¡A§Ú¬O¤p¾Ç¥Í¡A¤£¯à¤U¸üÀɮסA¬O­Ó¤p§¾«Ä¡I

TOP

¦^´_ 2# heavenweaver


    ÁÂÁ´£¿ô¡I§Ú¦A¸Ñ¨M¤F
·s¤H¤@ªT

TOP

¦^´_ 3# eric093
  1. If Not xrange Is Nothing Then
  2.     xrange.EntireRow.Delete
  3.     MsgBox "§ó·s§¹¦¨" & Now()
  4. Else
  5.     MsgBox "µL¶· §ó·s"
  6. End If
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE


    ÁÂÁª©¤j¡A§Ú¤]¬O³o»ò§ïªº¡I
·s¤H¤@ªT

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD