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

[­ì³Ð] ¥HÃöÁä¦r¿z¿ï¦h­Ósheetsªº¸ê®Æ

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-5-12 22:34 ½s¿è
Cells.ClearContent¨Ã¤£·|IJ°Ê worksheet_change
sunnyso µoªí©ó 2013-5-12 22:25

¦^´_ 7# c_c_lai

¹ï¤£°_¨S¦³¼g§¹´N«ö¿ùÁä
Cells.ClearContent¨Ã¤£·|IJ°Ê worksheet_change
¥ÎCells(4,1)=¡§¡¨, ¨ÓIJ°Ê§ó¦³®Ä²v.
ÁÂÁÂ.
ss

TOP

¦^´_ 9# GBKEE

·PÁÂGBKEE¤j¤jªºcode, ®Ä²v§ó°ª
¦³¤@ÂI¤p¤pªº¦a¤è¡A´N¬O¦pªGdatasheet(i) ªºAÄæ³Ì«á¤@¦C°²¦p¦]爲¿é¤J¿ù»~¬°ªÅ¥Õ·|¥X¿ù
¦pªG§â
    Cells(Rows.Count, "A").End(xlUp).Row
§ï爲
    UsedRange.Rows.Count
¦n¹³¥i¥HÁקK¡C¤£ª¾¹D³o¼Ë§ï§´·í¶Ü¡H
ss

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2013-5-13 07:01 ½s¿è
Cells.ClearContent¨Ã¤£·|IJ°Ê worksheet_change
sunnyso µoªí©ó 2013-5-12 22:25

§A¼gªº¤º®e¯uªº«Ü¤£¿ù¡A¤]ÆZ¦³ºc«äªº¡C GBKEE ªº¸É¥R¤]ÆZ¨ãÅé¹ê¥Î¡C
¤£¦n·N¬O¡B¸É¥R¤@¤U§Ú«üªº¬O¬õ¦âªº Cells(4, 1) = ""¡A¦Ó«D   
Cells.ClearContent¡A¦]¬°¦b¤@¶}©l©Ò¦³¤º®e§¡³Q²M°£±¼¤F¡A
¤§«á·í  Cells(4, 1) ¡B Cells(4, 2)¡B Cells(4,3)¡B Cells(4, 4)¡B
©ÎªÌ¬O Cells(4, 5) ¤º®e¤¤¦³©Ò¥ô¦ó¤@²Õ²§°Ê®É¡A«K·|IJµo
worksheet_change()¡C

TOP

¦^´_ 1# sunnyso


    ®¼§®ªºªF¦è¡Aªº½T¬O¦³³Ð·Nªº·Qªk
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD