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

[µo°Ý] Destination°ÝÃD½Ð±Ð

[µo°Ý] Destination°ÝÃD½Ð±Ð

DEAR  ALL ¤j¤j
1¥Îcopy destination ¥i¥H¥u¶K¤W¡¨­È¡¨
§Úcode¦p¤U¡A¦pªG§Ú¥u­n¶K¤W¡¨­È¡¨­n«ç§ï?
Selection.Copy Destination:=Worksheets("ÂI¦ì¿z¿ï").Cells(target§å¸¹°_©l¦C_r + 1, target§å¸¹°_©l¦C_c + 5)
2.·Ð¤£§[½ç±Ð  THANKS*10000
ù

¦^´_ 1# rouber590324

¤@©w­n°õµÛ¥ÎDestination¶Ü??
¥i¥HÂà­ÓÅs§ï³o¼Ë¶Ü??
Selection.Copy
Worksheets("ÂI¦ì¿z¿ï").Cells(target§å¸¹°_©l¦C_r + 1, target§å¸¹°_©l¦C_c + 5).PasteSpecial Paste:=xlPasteValues

TOP

DEAR  jcchiang ¤j¤j
·PÁ«ü¾É  THANKS*10000
ù

TOP

DEAR  ALL ¤j¤j
1.¨Ï¥Î¹Ï¤@ Selection.Copy ¡A¦ý¬Oµo²{¶]°_¨Ó«ÜºC¡A±À´ú¥i¯à¬O­n¦b¤£¦Psheet¶¡¤Á´«
©Ò¥H·Q§ï¥ÎSelection.copy destination
¦ý³o­Ó¦n¹³¤£¯àª½±µ¶K¤W­È
2.½Ð±ÐÁÙ¦³¨ä¥L¤èªk¶Ü???
¹Ï¤@
Selection.Copy
Worksheets("ÂI¦ì¿z¿ï").Cells(target§å¸¹°_©l¦C_r + 1, target§å¸¹°_©l¦C_c + 5).PasteSpecial Paste:=xlPasteValues
ù

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD