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

[µo°Ý] (¤v¸Ñ¨M!)½Ð¤j½¼­Ì«ü¾É¤@¤U§Ú³o¬q¥N½X : Ãö©ó Row.Deleteªº°ÝÃD

[µo°Ý] (¤v¸Ñ¨M!)½Ð¤j½¼­Ì«ü¾É¤@¤U§Ú³o¬q¥N½X : Ãö©ó Row.Deleteªº°ÝÃD

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2011/7/27 13:59): ­þÃȤH¬O¤j½¼ ¼Æ¤J°A¦ÛÆ_´îâí

¥»©«³Ì«á¥Ñ StanleyVic ©ó 2011-7-28 14:43 ½s¿è



´N¦p¤W¹Ï,§Ú·Q§â Cells(i,"A") ="" ªºªÅ®æ,delete. ¦Ó¥B­nXLUP..
¦ýµL©`,¤£¤~...¦º´`Àô¤F..

§Ú¤W­±¥´¿ù¦r i=i-1 ( §Ú¥´¿ù¤F.. i=i=1)

½ÐÀ°§U­×¥¿¤@¤U.ÁÂÁÂ~
NeverTry , NeverNo !

¦^´_ 1# StanleyVic


    °ò¥»¤W§R°£Àx¦s®æ¥²¶·¥Ñ¤U©¹¤W³v¤@§R°£
©Ò¥H§AÀ³¸Ó¥Î
for i =[A65536].end(xlup).row to 1 step -1
  if cells(i,1)="" then cells(i,1).delete shift:=xlup
next
¦pªG¬OªÅ¥ÕÀx¦s®æ¨Ã¤£¬O¤½¦¡¶Ç¦^ªÅ¥Õ
¨º¥Î½s¿è/¨ì/¯S®í/ªÅ¥ÕÀx¦s®æ
°µ¤@¦¸©Ê§R°£·|§Ö¤@ÂI
³o¤èªk¥Î¿ý»s¥¨¶°´N¥i¥H¨ú±oµ{¦¡½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¸U¤À·PÁ§Aªº«ü¾É.¬°§Ú¸Ñ¶}§x¹Ò¤F. ¦]¬°§Ú´N¬O§x¦b delete «á¤S³v¤W. ­P¨Ï§Ú¤£°±ªº¦º´`Àô.
ÁÂÁ§Aªº±Ð§Ú¥Ñ¤U¤è¦V¤W§PÂ_ªº¤èªk..

¬°¤F·Q¦h¤F¸Ñ.·Q¦A·÷·Ð§A¤@¤U¸ÑÄÀ : For i = [A65536].End(xlUp).Row To 1 Step -1
³o­Ó Step -1 ¬O¤£¬O«ü¥Ñ¤U¦Ü¤W¨C¤@¦¸ i ³£-1 ªº·N«ä..? ÁÙ¬O..
NeverTry , NeverNo !

TOP

¦^´_  Hsieh


    ¸U¤À·PÁ§Aªº«ü¾É.¬°§Ú¸Ñ¶}§x¹Ò¤F. ¦]¬°§Ú´N¬O§x¦b delete «á¤S³v¤W. ­P¨Ï§Ú¤£°±ªº¦º ...
StanleyVic µoªí©ó 2011-7-27 14:52


>¬°¤F·Q¦h¤F¸Ñ.·Q¦A·÷·Ð§A¤@¤U¸ÑÄÀ : For i = [A65536].End(xlUp).Row To 1 Step -1
>³o­Ó Step -1 ¬O¤£¬O«ü¥Ñ¤U¦Ü¤W¨C¤@¦¸ i ³£-1 ªº·N«ä..? ÁÙ¬O..
´N¬O1¦æ1¦æ¤U¦Ü¤Wªº·N«ä
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

³o­Ó Step -1 ¬O¤£¬O«ü¥Ñ¤U¦Ü¤W¨C¤@¦¸ i ³£-1 ªº·N«ä
For i=II   to  III  Step  -5    ªº°j°é
II  <   III  Step  5    ¥Ñ¤p¨ì¤j  Step ¬O¥¿¼Æ
II   >  III  Step  -5  ¥Ñ¤j¨ì¤p  Step ¬O­t¼Æ

TOP

·PÁ§A­ÌµL¨pªº±Ð¾É.. (¤v¸g¾Ç²ß¤F.. )
¤@ª½³£¥H¬°¥u¥i¥H ¥Ñ"¤p" to "¤j".. ­ü~¯u¬O¾Ç®üµL²P..
NeverTry , NeverNo !

TOP

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