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

´¡¦æ°ÝÃD

´¡¦æ°ÝÃD

½Ð°Ý¦U¦ì¤j¤j
§Ú·Q¦bsheet1¤¤´¡¤Jn¦æ¡Asheet2¤]´¡¤Jn¦æ
½Ð°Ý­n¦p¦ó¥ÎVBAªí¹F¡H

¦^´_ 1# jamce_su


    ¥ý¥Î¿ý»s¥¨¶°±o¨ì°ò¥»µ{¦¡½X
¥hÁA¸Ñ¦U«ü¥O·N¸q
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Úª¾¹D´¡¤J1¦æ¬O¦p¤U
    Rows("10:10").Select
    Selection.Insert Shift:=xlDown
¦ý¬O¦pªG¬O­n´¡¤Jn¦æ©O¡HÀ³¸Ó¦p¦ó¡H

    Rows("10:" & n + 10 &"").Select
   Selection.Insert Shift:=xlDown
³o¼Ë¹ï¶Ü¡H§Ú¸Õ¤£¥i¥H£z£°

TOP

¦^´_ 3# jamce_su


    n­nµ¹­È£«
n = 5
Rows("10:" & n + 10).Insert Shift:=xlDown
³o¼Ë´N¬O10:15¦C´¡¤J
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂHsieh¤j¤jÃDÂI

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD