Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Refer to a range outside the active sheet by qualifying the range reference with a worksheet name from the active workbook

Sub sheetRange()     Worksheets("Sheet1").range ("A1:C5") End Sub