To copy a range to a different worksheet or workbook, simply qualify the range reference for the destination.

 
Sub CopyRange2()
    Workbooks("File1.xls").Sheets("Sheet1").range("A1").Copy Workbooks("File2.xls").Sheets("Sheet2").range("A1")
End Sub

1.	Copy method can use an argument that represents the destination for the copied range.
2.	Copying a variably sized range
3.	Copy method has one argument - the destination range for the copy operation
4.	The Copy and Paste methods
5.	Copy a range
6.	Moving a range
7.	Moving a range: move a range by cutting it to the Clipboard and then pasting it in another area
8.	You can move a range with a single VBA statement
9.	Copy method can use an argument for the destination range

To copy a range to a different worksheet or workbook, simply qualify the range reference for the destination. : Range Copy Cut Paste « Excel « VBA / Excel / Access / Word