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

[µo°Ý] ½Ð°Ý¥¨¶° ¦p¦ó ¥i¥H³]©w ¦C ¬°ÅÜ°Ê [H2]¤ºªº­È¬° 5

[µo°Ý] ½Ð°Ý¥¨¶° ¦p¦ó ¥i¥H³]©w ¦C ¬°ÅÜ°Ê [H2]¤ºªº­È¬° 5

½Ð°Ý¥¨¶° ¦p¦ó ¥i¥H³]©w ¦C ¬°ÅÜ°Ê [H2]¤ºªº­È¬° 5

Sub Macro1()

    Range("C2:E2").Select
    Application.CutCopyMode = False
    Selection.Copy
        
    Range("C5:E5").Select  '·Q³]©w¦C "C5:E5" ¬°ÅÜ°Ê [H2]¤ºªº­È¬°5
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("H2").Select
End Sub
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# 7777


    Range("C" & [H2] & ":E" & [H2]).Select
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

·PÁÂ Hsieh ¤j¤j
¦ý µ²ªG³º ÅܱqC5 D5 E5  ½Æ»s¦¨ CÄæ DÄæ EÄæ ¾ãÄæ³£¬O£°¡C
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# 7777

H2½T©w¦³¼Æ­È¶Ü?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

ªü~~~  ¥»¤H¥¢»~ (¨S¦³ª`·N¨ì)  ·PÁ ¤j¤j

¤wOK ¸Ñ¨M  ÁÂÁÂ!!
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD