¾È³çÇϼ¼¿ä.
ÇöÀç ÆÄÀÏÀÌ ¾Æ´Ñ ´Ù¸¥ ÆÄÀÏ¿¡ Á¢±ÙÇØ¾ß ÇϹǷÎ
Äڵ尡 Á¶±Ý ´Þ¶óÁ®¾ß ÇÕ´Ï´Ù.
´ÙÀ½ ¿¹Á¦´Â ÇöÀç ÆÄÀÏÀÇ ÇöÀç ½ÃÆ®¿¡ ÀÖ´Â [A1:C6]À» º¹»çÇؼ FileB.xlsx ¶ó´Â ÆÄÀÏÀÇ
Sheet1 ¿öÅ©½ÃÆ®ÀÇ [B5]¼¿¿¡ ºÙ¿©³Ö´Â ÄÚµåÀÔ´Ï´Ù.
Worksheet °³Ã¼ º¯¼ö¸¦ ¼±¾ðÇÏ°í ¿©±â¿¡ ´ë»ó ÆÄÀÏÀÇ ´ë»ó ½ÃÆ®¸¦ ÁöÁ¤ÇÑ ´ÙÀ½
Copy ¸Þ¼µå¿¡¼ »ç¿ëÇß½À´Ï´Ù.
Äڵ带 ÀÀ¿ëÇÏ¸é ¿øÇÏ´Â ÀÛ¾÷À» ÇØ°áÇÒ ¼ö ÀÖÀ» °Í °°±º¿ä.
Sub Test() Dim rngTarget As Worksheet Set rngTarget = Workbooks("FileB.xlsx").Worksheets("Sheet1") Range("A1:C6").Copy rngTarget.Range("B5") End Sub
Àß µÇ½Ã±æ¿ä~
|