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

[µo°Ý] ½Ð°Ý§R°£ªÅ¥ÕÀx¦s®æ

[µo°Ý] ½Ð°Ý§R°£ªÅ¥ÕÀx¦s®æ

¦U¦ì¤j¤j¦n¡A¤p§Ì§Ú·Q­n§âCÄ檺ªÅ¥ÕÀx¦s®æ§R°£¡AµM«á©Ò¦³¸ê®Æ¤º®e©¹¤W»¼¸É¡A§Ú¦³¦bª©¤W§ä¨ì¤@­Ó»yªk¦p¤U¡G
Columns("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
¥i¬O³o¼Ë°õ¦æªº¸Ü¡A·|§âªÅ¥ÕÀx¦s®æªº¦P¤@¦C¤]¤@¨Ö§R°£±¼¡A
¦]¦¹·Q½Ð°Ý¬O§_¦³¨ä¥Lªº¼gªk¡A¯à°÷¶È¶È§R°£¸ÓÄ檺ªÅ¥Õ®æ¨Ã©¹¤W¶ñ¸É¡A¥B¤£­n¼vÅT¨ì¨ä¥LÄæ¡CÁÂÁÂ~~~

¸Õ¸Õ¬Ý
  1. Columns("C:C").SpecialCells(xlCellTypeBlanks).Delete
½Æ»s¥N½X

TOP

ÁÂÁÂuf¤j¡A¥i¥H¤F¡A¹ê¦b¬O«D±`·PÁ§A~
­ì¨Ó¬O®t¦bEntireRow¡A·P®¦~

TOP

¦^´_ 3# owen06
¦h¬Ý¬Ývba ªº¤èªk,ÄÝ©Ê,¨ç¼Æ,¤F¸Ñ²M·¡
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD