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

[µo°Ý] §ïÅÜÄæ¦C«á½Æ¨î°ÝÃD

[µo°Ý] §ïÅÜÄæ¦C«á½Æ¨î°ÝÃD

½Ð±Ð¦Ñ®v¦P¾Ç­Ì¡A·Q§âddeÁä±µ¥ÑE 1-10§ï¬°H 11-20½Æ»s¨ìA 1-10¡A¤½¦¡¤WÀ³«ç¼Ë§ï°Ê¡HÁÂÁÂ

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

¦^´_ 1# ²Â¤p«Ä
  1. Sub Ex()
  2.     Range("A1:A10").Value = Range("H11:H20").Value
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 2# GBKEE


    ¦¨¥\¤F¡AÁÂÁÂGBKEEª©¤jÀ°¦£¡C

TOP

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2012-2-22 17:33 ½s¿è

¦^´_ 3# ²Â¤p«Ä


  G¤jªº¥Îªk~ ­nª`·N½d³ò­ò~ «e«á­n¤@­P~
  ¤£µM¸ê®Æ·|§ì¤£»ô~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD