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

[µo°Ý] «ö¶s¨Ï¥Î°ÝÃD

[µo°Ý] «ö¶s¨Ï¥Î°ÝÃD

¥Î"0"¤@­Ó«ö¶s¯à§_¦P®É§â"B"¤º®ecopy¨ì"A"©M"D"¤º®ecopy¨ì"C"¡A½Ð«ü±Ð...ÁÂÁÂ


Sub «ö¶s0_Click()

    For i = 1 To 10
        Cells(i, "A").Value = Cells(i, "B").Value
    Next i

End Sub

¦^´_ 1# ²Â¤p«Ä
¤£¬O´N¥[¤JC¡BDªº°Ê§@¶Ü?
  1.     Sub «ö¶s0_Click()

  2.     For i = 1 To 10
  3.         Cells(i, "A").Value = Cells(i, "B").Value
  4.         Cells(i, "C").Value = Cells(i, "D").Value
  5.     Next i

  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁª©¥D«ü¾É¡A¦¨¥\¤F¬O¥i¥Hªº¡C

TOP

Sub «ö¶s0_Click()

    For i = 1 To 10
        Cells(i, "A").Value = Cells(i, "B").Value
        Cells(i, "C").Value = Cells(i, "D").Value
        Cells(i, "E").Value = Cells(i, "F").Value
        Cells(i, "G").Value = Cells(i, "H").Value
        Cells(i, "I").Value = Cells(i, "J").Value
        Cells(i, "K").Value = Cells(i, "L").Value
    Next i

End Sub

¥H¤W¤½¦¡¶i¦æÂлs®É®É¶¡¸û­@¡A¦³¤èªk¸Ñ¨M¶Ü¡HÁÂÁÂ

TOP

¦^´_ 4# ²Â¤p«Ä
  1. Sub «ö¶s0_Click()

  2.     R = 1
  3.     For R = 1 To 11 Step 2
  4.       For I = 1 To 10
  5.         Cells(I, R).Value = Cells(I, R + 1).Value
  6.       Next I
  7.     Next R

  8. End Sub
½Æ»s¥N½X

TOP

Sub «ö¶s0_Click()

    For i = 19 To 44
        Cells(i, "H").Value = Cells(i, "L").Value
        Cells(i, "N").Value = Cells(i, "R").Value
        Cells(i, "T").Value = Cells(i, "X").Value
        Cells(i, "Z").Value = Cells(i, "AD").Value
        Cells(i, "AF").Value = Cells(i, "AJ").Value
        Cells(i, "AL").Value = Cells(i, "AP").Value
    Next i
        
End Sub

ÁÂÁÂregister313ªº¦^ÂСA¦p§Ú§âÄæ©M¦C§ïÅܤF¡AÀ³«ç¼Ë­×§ï¤½¦¡¡H

TOP

¦^´_ 6# ²Â¤p«Ä
Åܼƪº³W«h­n¦Û¤v«ä¦Ò¤@¤U
For i = 19 To 44 '«ü©w¦C
   For j = 8 To 42 Step 6 '«ü©wÄæ¡A¨C¦¸¸õ6Äæ
      Cells(i, j).Value = Cells(i, j).Offset(, 4).Value  '¼g¤J¦V¥k4Ä檺­È
   Next
Next
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh


    ÁÂÁÂHsiehª©¥D¦^ÂСA«Ü²M·¡¸ÑÄÀ­×§ï¤èªk¡A³oÂлs°Ê§@»Ý®É9¬í§¹¦¨¡A¦³§ó§Ö§¹¦¨ªº¤èªk¶Ü¡H

TOP

¦^´_ 8# ²Â¤p«Ä
¤£·|§a!­n¥Î¨ì9¬í?
À³¸Ó¬O§A¤u§@ªí¤½¦¡«D±`½ÆÂø¤~·|¦p¦¹¯Ó®É
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  ²Â¤p«Ä
¤£·|§a!­n¥Î¨ì9¬í?
À³¸Ó¬O§A¤u§@ªí¤½¦¡«D±`½ÆÂø¤~·|¦p¦¹¯Ó®É
Hsieh µoªí©ó 2011-12-18 21:53



    ¤å¥ó¥u¦³600k¡AÂлs¸ê®Æ®Écpu·l¯Ó¸ê·½50%¥H¤W¡AÀ³¸Ó¬Oµw¥ó¸ê·½¤£¨¬ªº°ÝÃD¡C

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD