Refer to a range outside the active sheet by qualifying the range reference with a worksheet name from the active workbook : Range Reference « Excel « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Excel » Range Reference 




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

 
Related examples in the same category
1.Reference a range by name
2.To refer to a range in a different workbook
3.Refer to an entire row
4.Refer to an entire column
5.Noncontiguous ranges
6.Select a range A1:A3
7.Activate the Range
8.Use disgonal cells to select a range
9.Use ActiveCell.End to select a range
10.Use the cell reference directly
11.Select a range by using the ActiveCell
12.Refer to the B2 cell in DataInput, while another workbook is active
13.Select Last Cell
14.The Offset method can also use negative arguments. A negative row offset refers to a row above the range. A negative column offset refers to a column to the left of the range.
15.Use 0 as one or both of the arguments for Offset: expression refers to cell A1
16.returns a range object that represents the last non-empty cell in the same row
17.Using the End Property to Navigate within a Worksheet
18.Using the Range Property to Refer to Groups of Cells
19.Specifying Individual Cells with the Cells Property
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.