Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To refer to a range in a different workbook

Sub bookRange()     Workbooks("Budget.xlsx").Worksheets("Sheet1").range ("A1:C5 ") End Sub