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

½Ð°Ý¦p¦ó§R°£¦h¾lªÅ¥Õªº¸ê®Æ¦C

½Ð°Ý¦p¦ó§R°£¦h¾lªÅ¥Õªº¸ê®Æ¦C

½Ð°Ý¦U¦ì¥ý¶i
¦³®É­Ô·í§Ú­Ì·|®³¨ì¦³®æ¦¡ªºExcel¸ê®Æ¡A¦ý¬O³o¼Ëªºªí®æ¹ï­n°µ¸ê®Æ¤ÀªR³B²z«Ü³Â·Ð¡A
³o¥÷¸ê®Æ¡A¨C¹j´Xµ§ªÅ¥Õ¡A¤S­«ÂФW­zªº¸ê®Æ¡A½Ð°Ý¦p¦ó§R°£³o¨Ç¦h¾lªÅ¥Õªº¸ê®Æ¦C
Åý¥¦¦¨¬°¥¿³Wªº¸ê®Æªí..ÁÂÁÂ

¥h°£ªÅ¥Õ¦h¾l¦Cªº¸ê®Æ.rar (4.15 KB)

¦^´_ 1# PD961A
  1. Sub nn()
  2. With Range("A2", [A65536].End(xlUp))
  3. .Replace "½s¸¹", ""
  4. .SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  5. End With
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

±N¸ê®ÆÄæ¸ê®Æ½Æ»s¨ì·sªí
¥Î½s¿è¨ú¥N¥\¯à±N²Ä2¦C¥H¤Uªº"½s¸¹"¦r¦ê²MªÅ
¿ï¨ú¸ê®Æ²Ä¤@Äæ
½s¿è/¨ì ªÅ®æ
¥kÁä§R°£/§R°£¾ã¦C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# PD961A


   
¥¼©R¦W.png
2010-7-17 16:48
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥t¥~¤£¦n·N«ä¥¦¥i¥H¤£¥Î¥Î¨ìVBA¶Ü??ÁÂÁÂ!!
PD961A µoªí©ó 2010-7-17 15:28



¦pªGAÄæ¬O¼Æ¦r½s¸¹
¥i¥H¥Î¶i¶¥¿z¿ï
¶i¶¥¿z¿ï.jpg
2010-7-18 00:09
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 8# asimov

ÁÂÁ±z
¦ý¬O¨Ì·Ó±zªº¨BÆJ¥L·|Åã¥Ü¨ì¥t¤@­Ó¦Û¿ïªºÀx¦s®æ.¨Ã¥B¥²¶·¹w³]·Ç«h½d³òÄæ
©Ò¥H¸ê®Æ¿z¿ï«á¤£·|¬O¦b­ì¨ÓªºA~Bªº¦ì¤l...ÁÙ¬OÁÂÁ±zªº¦^¤å

1.gif
2010-7-18 15:24


2.gif
2010-7-18 15:24

TOP

¦^´_ 7# PD961A


    ¥i¨£§A®Ú¥»¨S¦³¤F¸Ñµ{¦¡½X,¥u¬O¤@¨ý®M¥Î
§Ú´£¨Ñªºµ{¦¡½X¬O°w¹ï§@¥Î¤¤ªº¤u§@ªí¸ê®Æ°µ¾ã²z
¥u­n§A§â­ìSHEET1ªº¸ê®Æ½Æ»s¨ìSHEET2«á°õ¦æ´Nª¾¹D¬O¬Æ»ò­ì¦]¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Ú¤£¤Ó·|¥Î VB¡A©Ò¥H¥Î¤F¤U­±ªº¤è¦¡

(1) ¤u¨ã¦C ¡÷  ½s¿è \ ¨ì  ==>¡u¯S®í¡v ==>¿ï¾Ü ¡uªÅ®æ¡v «á«ö½T©w
§ä¨ìªÅ®æ¦ì¸m.JPG
2010-8-11 17:23

(2) §ä¨ìªÅ¥ÕÀx¦s®æ«á¡A«ö¥kÁä¡A§R°£¡i¤U¤èÀx¦s®æ¤W²¾¡j«á«ö½T©w
¤U¤èÀx¦s®æ¤W²¾.JPG
2010-8-11 17:26

(3) ªÅ¥Õ¦C´N·|¦Û°Ê§R±¼©¹¤W±µÄò¹Æ
§¹¦¨¤F.JPG
2010-8-11 17:27


³o¼ËOK¶Ü?

TOP

¦^´_ 8# jennylu520


    ±z°µªº¤è¦¡«Ü¦n£«....´N¬OEXCELªº°ò¥»¥\
      ÁÙ¥i¥H¥t¥~¾ÇHSª©¥Dµ¹ªº¤è¦¡..«Ü¬Ûªñ³á
      VBAµ{¦¡½Xªº³¡¥÷..¦]¬°«á¨Ó¤w¸g·|¤F..©Ò¥H¨S¦³¦A¦^¤å
      ±z¥i¥H®Ú¾ÚHSª©¥Dµ¹ªºµ{¦¡½Xª½±µ¸Õ¸Õ¬Ý..
    ÁÂÁ±zªº¦^¤å....
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

ª½±µ¿ï¨ú¾ã­Ó column, ¥Î¡§¿z¿ï¡¨¿ï¥X©Ò¦³ªÅ¥Õ row, ¥þ³¡§R°£«á¡A ¦A¨ú®ø¡§¿z¿ï¡¨§Y¥i¡C

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD