Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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