[µo°Ý] Ãö©ó¸ó¤u§@ªíªº°Ñ·Ó°ÝÃD..

saleen

¤j®a¦n  ¤p©f¤S¨Ó´£°Ý¤F

·Q½Ð°Ý°²³]§Ú¦³¨â­Ó¤u§@ªí 1 ¸ò 2
¦pªG·Q­n¥Îµ{¦¡³]©w
¤u§@ªí 1 ªº A2 ~ Z2 ­nµ¥©ó ¤u§@ªí 2 ªº A2 ~ Z2 ªº­È
À³¸Ó­n«ç»ò¼g©O ?
³Ì¦³®Ä²vªº¼gªk·|¬O¤°»ò..


¬Ý¦ü²³æ¤p©f«o¬O¸Õ¤F¦n¦hºØ¼gªk³£¤£¦¨¥\ ><
·Ð½Ð¤j¤j­Ì±Ï±Ï¤p©f¤F Orz

ashan0418

¦^´_ 1# saleen

Sheets("¤u§@ªí2").Range("A2:Z2").Copy Sheets("¤u§@ªí1").Range("A2")

saleen

¦^´_ 2# ashan0418


    ·PÁÂ Ash ¤j¦^´_
¨º¦pªG§Ú­nªº¬O­È±o¸Ü
¥i¥H§ï¦¨
Sheets("¤u§@ªí2").Range("A2:Z2").value.Copy Sheets("¤u§@ªí1").Range("A2").value
¶Ü ?
³o¼Ë©Ç©Çªº

ashan0418

¦^´_ 3# saleen


    Sheets("¤u§@ªí2").Range("A2:Z2").Copy
    Sheets("¤u§@ªí1").Range("A2").PasteSpecial Paste:=xlPasteValues

saleen

¦^´_ 4# ashan0418

Ash ¤j¤j , §Ú¥i¯à­n´«­Ó¤è¦¡°Ý ~
§Ú²{¦bªºµ{¦¡½X¬Oªø³o¼Ë :

Sub Ref()
    ¤u§@ªí3.Cells(2, 1) = ¤u§@ªí1.Cells(2, 1)
    ¤u§@ªí3.Cells(2, 2) = ¤u§@ªí1.Cells(2, 3)
    ¤u§@ªí3.Cells(2, 3) = ¤u§@ªí1.Cells(2, 3)
                                       .
                                       .
                                       .
End Sub

¦]¬°¤u§@ªí 1 ¬O DDE
©Ò¥H³o¼Ëªº¸ÜÀ³¸Ó­n«ç»ò¼g·|¤ñ¸û¦n©O ~? ><
§Ú¸Õ¹L , ¥Î½Æ»s¶K¤Wªº¤è¦¡¦ü¥G·|¦³°ÝÃD T_T
¬O¤£¬O¥i¥H¥Î Range ¨Ó¼g , ¦ý¬O§Ú¤S¤£ª¾¹DÀ³¸Ó«ç»ò¼g³Ì¦³®Ä²v :'(

ashan0418

¦^´_ 5# saleen


Sheets("¤u§@ªí1").Range("A2:" & [iv2].End(xlToLeft).Address).Copy
Sheets("¤u§@ªí3").Range("A2").PasteSpecial Paste:=xlPasteValues   


³o¼Ë¸Õ¸Õ!!

saleen

¦^´_ 7# ashan0418


    ³o¼Ë¥Î¦ü¥G¥i¦æ
¦ý³o¼ËÁÙ¬O¥d¨ì§Ú¤W¤@­Ó¨S¤HÀ°§Ú¸Ñµªªº°ÝÃD T_T
http://forum.twbts.com/thread-13247-1-1.html
¤£ª¾¬°Ô£¥Î³oºØ¼gªk
¹Ïªíªº ¼Æ¦C­È ´N·|¸òµÛ¶]±¼...

±Ï©R°Ú !!!!