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

[µo°Ý] ¦p¦ó¦b¨C·í°Å¤U¤@¦æ®É¥t¤@¦æ·|¦Û°Ê¸É¤W?

¦^´_ 9# oobird

¤j¤j¡A¦n¯«©_¡I·Qª¾¹D¦p¦ó¿ì¨ìªº,too¡I½Ð§iª¾¡AÁÂÁ¡I

TOP

¥Î¤u§@ªíactivate¨Æ¥ó
¦b§A°Å¤UÀx¦s®æ¶K¨ì¨ä¥L¤u§@ªí«á¡A¦^¨ìªí¤@®É´N·|§R°£ªÅ¥Õ®æ
¦p¹Ï³]¸m

TOP

½Ð°ÝSpecialCells(4).Delete (2)
(4)»P(2)¥Nªí¤°»ò·N«ä©O?
ÁÙ¦³­þ¸Ì¥i¥H¬d³o¨Ç¥N¸¹©O?
YOYO

TOP

SpecialCells(4).Delete(2) = SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
excelÀ°§U¤¤¨Ã¨S¦³¼Æ¦r¥Nªíªº°Ñ¼Æ¤Î¬ÛÃö»¡©ú©Î¯Á¤Þ¡A¥u¯à¦b³v¨B°õ¦æ®É·Æ¹«©ñ¦b°Ñ¼Æ¤¤¬ÝÅã¥Üªº¼Æ¦r¡A¦p©ñ¦bxlCellTypeBlanks¤¤·|Åã¥Ü4¡A¦Û¤v°O¤U¨Ó¡C¦p¯à°O¦í°Ñ¼Æ­Ë¤£«Øij­I¼Æ¦r¡C§Ú­Ó¤H¤£·|»{¨§ªÞ¦r¡Aı±o­I¼Æ¦r¤ñ­I¨§ªÞ®e©ö¤~·|¥h­Iªº¡I

TOP

¦^´_ 14# oobird


¦n¤è«Kªº¤èªk~¾ÇµL¤îºÉ
·PÁ¶DZÂ~¯uªº«Ü¹ê¥Î
¶}¤ß¾Ç²ß,¾Ç²ß«Ü¶}¤ß

TOP

§ÚÆZ±`¥Îªº¤è¦¡¦³¤G:
1.  ±N¸ê®Æ½d³òÂন²M³æ«á´N¥i¥H»´©ö°µ¨ì¤F
2.  ±N¤£·Q­nªº¸ê®Æ¦C¿z¿ï«áª½±µ¿ï¨ú§R°£§Y¥i
§Ú¦³½d¨ÒÀÉ, ¥i¬O¤£ª¾¥i§_¤W¶Ç,¦]§Ú­è¥[¤J¦Ó¤w.

TOP

ª©¥D¬O¥Hvba¹ê²{»Ý¨D
Kenny

TOP

DAER SIR
·Ð½T»{¦pªþÀɦ³µL²Å¦X±z¤§»Ý¨D
A¤u§@ªí°Å¦ÜB¤u§@ªí
A¤u§@ªí¤§ªÅ¥Õ¦C¦Û°Ê§R°£   THANKS

1.rar (7.69 KB)

TOP

¾ãÄæ(¦C)°Å¤U¡A¾ãÄæ(¦C)´¡¤J´N¥i¥H¤F
marklu

TOP

¦^´_ 1# Qin


    §A¥i¸Õ¸Õ¡y°Å¤U¡z¸Ó¦C«á¡A­n¶K¨ì¨ä¥L¦C®É¤£­n¥Î¡y¶K¤W¡z¥\¯à¡A§ï¥Î¡y´¡¤J°Å¤UªºÀx¦s®æ¡z¶K¤W®É¡A­ì°Å¤U¦Cªº¤U¤@¦C·|¦Û°Ê»¼¸É¤W¥h¡C
peter460191

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD