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

¤£³sÄòÀx¦s®æ¸Ó¦p¦ó©ì¦²?

¤£³sÄòÀx¦s®æ¸Ó¦p¦ó©ì¦²?

½Ð°Ý¦U¦ì¤j¤j¡G
¤@¯ëexcel¥i¥H°µ³æ¤@Àx¦s®æ©Î³sÄòÀx¦s®æªº©ì¦²....
¥i­Y¦³¤£³sÄòÀx¦s®æªº¸ê®Æ­n¦P®É©¹¤W©ì¦²²¾¤@®æ­n¦p¦ó¥Î©O..??

¦pªG¬O¥þ³¡³æ¯Â©¹¤W¤@®æªº¸Ü¡K§Ú¥u·|¥H¤U¤èªk
°²¦p­nB3¡BD4­n©¹¤W²¾ªº¸Ü¡Aª½±µ¿ïB2¡BD3¦A·Æ¹«¥kÁä¡÷§R°£¡÷¤U¤èÀx¦s®æ¤W²¾¡÷½T©w
§Ú«Üµæ¡A­è®Ì¨ì³oºô¯¸¨S¦h¤[

TOP

¦^´_ 2# www0857


    ¤£¦n·N«ä.....¦]¬°¤£·Q¥Î§R°£Àx¦s®æ...¤~·Q¥Î©ì¦²ªº¤è¦¡......
¨º·N«ä¬OEXCEL¥u¯à°µ³sÄòÀx¦s®æªº©ì¦²...¥u­n¬O¤£³sÄòªºÀx¦s®æ´NµLªk°µ©ì¦²¶Ü...??

TOP

¥»©«³Ì«á¥Ñ linshin1999 ©ó 2011-1-6 10:03 ½s¿è

Jumky©p¦n:¦pªG¥Î¥¨¶°«ü¥O¥iÄ@·N¥G?
Sub ·h²¾Àx¦s®æ¸ê®Æ
    Range("C4").Cut
    Range("D7").select
    ActiveSheet.Paste
End Sub


¦pªG«Ü¦hªº¸Ü,©p¥i¥H¥Î¨â­Ó°}¦C¨Ó°µ¹ï¦Qªº¤u§@¦p¤U:

Sub ·h²¾Àx¦s®æ¸ê®Æ
    Dim delete_data, copy_data
    delete_data = Array("A5", "B9", "C2", "G3", "D5", "E4", "F7")
    copy_data = Array("A9", "B2", "C6", "G5", "D2", "E7", "F2")
    Dim i As Integer
    For i = 0 To 5
        Range(delete_data(i)).Cut
        Range(copy_data(i)).select
        ActiveSheet.Paste
    Next i
End Sub


¸Õ¸Õ¬Ý«Ü¦nª±ªº
V98

TOP

¼Ó¥D±z¦n
´£¨Ñªº°T®§±ø¥ó¤£¤Ó¥R¨¬,¥i§_¤W¶ÇÀÉ®×½d¨Ò?
¦pªG³o¨Ç¤£³sÄòÀx¦s®æ,¦³¤@©wªº³W«ß(¤ñ¦p¤º§t¬Y¤@¤¤­^¼Æ¦r;©Î¦P¤@¤é´Á®É¶¡,©Î¨ä¥L¬ÛÃö¥i¯àªº±ø¥ó),©Î¬O³o¨ÇÀx¦s®æªº¤W¤U¤@®æ¾Ö¦³¯S©wª¬ªp,©Î¬O«e«áÀx¦s®æ¨ã³Æ¬YºØ±ø¥óÄݩʵ¥µ¥¥i¨Ñ¿z¿ï°Ñ¦Ò,¨ºÀ³¸Ó¦³³\¦h²{¦¨ªºexcel¥\¯à¥i¨Ñ§Q¥Î,¥Ø«e°T®§¤£¨¬¥H§PÂ_,«Øij¤W¶Ç­ÓÀÉ®×Åo~

TOP

Sujane0701§A¦n:§ï¦n¤F(¦p«e¤å)¦A¥h°õ¦æ¬Ý¬Ý.§Ú没¦³¸ÕÄݩʤ£¦PªºÀx¦s®æªºÂಾ,§A½Íªº³¡¤À§Úªº¸gÅ礣°÷,¤£¦n·N«ä,§ÚªºÀɮ׳æ¯Â¬O´ú¸Õ©Ê½è,©Ò¥H¥u¬O²³æªº¦P«¬ºAªºÀx¦s®æªº²¾Âà,®£©È没¦³¤W¶Çªº·N¸q,ÁÂÁÂ!!
V98

TOP

¦^´_ 6# linshin1999


    linshin1999¤j¤j±z¦n¡G
  ¦]¬°§Ú­Ì¨º­Ó¤@­Óªí®æ¼Æ­Ó¤H¦b¨Ï¥Î...©Ò¥H...µLªk¥h¥Î¥¨¶°...©Ò¥H¤~·Q»¡¬O§_¦³¤£³sÄòÀx¦sªº©ì¦²¤è¦¡...
   ¦U¦¡¦p¤U¡G
   Book2.rar (1.67 KB)

TOP

¥u¦³§R°£ªÅ¥ÕÀx¦s®æ¤@ªk
¿ï¨úA1:B6
«öF5/¯S®í
ÂI¿ïªÅ®æ
·Æ¹«¥kÁä/§R°£/¤U¤èÀx¦s®æ¦V¤W²¾°Ê
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# jumky


    ¯à¦P·N¥Î»²§U¦C¶Ü?
¦pªG¥i¥H§Ô¨ü¼W¥[¤@Ä滲§U¦C,¤p§Ì´£¨Ñ¤@­Ó¤èªk
=IF(A1="","",ROW(A1)) ©¹¤U«þ¨© ¥i¥H­pºâ¥X«DªÅ¥ÕÀx¦s®æªº¦ì§},µM«á¥H»²§UÄæ°µ±Æ§Ç°Ñ·Ó­È§Y¥i¸Ñ¨M°ÝÃD

TOP

¦A´£¨Ñ¤@­Ó¤£¼W¥[»²§UÄæ,¯Â¤â°Êªº¨ú¥©¤èªk
1.¨ÌHsieh ª©¥D¤j¤jªº¤è¦¡,¾Þ§@¨ì°é¿ï©Ò¦³ªÅ¥ÕÀx¦s®æ³o­Ó¨BÆJ°±¤U
2.¤£§R±¼ªÅ¥ÕÀx¦s®æªº«e´£¤U,§Ú­Ì¥i¥H§ï¥Î"¨ú¥N"¥\¯à,±NªÅ¥ÕÀx¦s®æ¥þ³¡§ï¦¨[¤@©w·|³Q±Æ§Ç¨ì³Ì¤U¤è]ªº¤å¦r©Î¼Æ­È,¤ñ¦pZZZZZ,µM«á°é¿ï¾ã±i¤u§@ªí,¥H"ZZZZZ"©Ò¦bÄæ¦ì°µ±Æ§Ç¥D­nÁä
3.±Æ§Ç§¹¦¨,ÂI¿ï"ZZZZZ"³o­ÓÄæ¦ì,¥Î"¨ú¥N"¤è¦¡Á٭즨ªÅ¥Õ

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD