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

[µo°Ý] ¬°¤°»ò~§Úªº¸ê®Æ·h²¾®É·|¤@ª½¥X²{¼u¸õµøµ¡¡I¡I¡I

[µo°Ý] ¬°¤°»ò~§Úªº¸ê®Æ·h²¾®É·|¤@ª½¥X²{¼u¸õµøµ¡¡I¡I¡I

:'(
For K=1 to 250
Worksheets("ÀɦW¸ê®Æ").Cells(K, 3).Value = Cells(K, 1)
Worksheets("ÀɦW¸ê®Æ").Cells(K, 4).Value = Cells(K, 5)
Worksheets("ÀɦW¸ê®Æ").Cells(K, 5).Value = Cells(K, 10)
Next K

§Ú¨Ï¥ÎEXCELªºVBA¼g¤F¤@¤p¬q¤u¨ã¨ó§U§Ú·h¤u§@ªí¤ºªº¸ê®Æ¡A¤j­P¦p¤W
¥i¬O¹Lµ{¤¤¤@ª½¥X²{¤U­±ªºµe­±¡A
¨Ï±o¥²¶·«ö¤U¡© ½T©w¡©¡A¤~¯àÄ~Äò°õ¦æ¡K
½Ð±Ð¦U¦ì¤j¤j¦p¦óÁקK¥¦¤@ª½¥X²{ÁÙ¯àÄ~Äò°õ¦æ©O¡H ÁÂÁÂ~~~·P®¦~~~~~

¦^´_ 1# ji12345678

  
    Application.DisplayAlerts = False Ãö³¬¸ß°Ýwindows
   Application.DisplayAlerts = True   Åã¥Ü¸ß°Ýwindows.¦ý¹ï¥¨¶°µøµ¡µL®Ä!!

TOP

¦^´_ 1# ji12345678


    À³¸Ó¬O¦³¦X¨ÖÀx¦s®æ¦s¦b¡A¨ú®ø¦X¨ÖÀx¦s®æ¸Õ¸Õ¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD