Your VBA help file has lots of information on how to properly refer to cells without "Selecting" or making the sheet Active.
Referring to Cells and Ranges by Using A1 Notation
You can refer to a cell or range of cells in the A1 reference style by using the Range property. The following Sub procedure changes the format of cells A1:D5 to bold.
.Font.Bold = True
The following table illustrates some A1-style references using the Range property.
Range("A1") Cell A1
Range("A1:B5") Cells A1 through B5
Range("C5:D9,G9:H16") A multiple-area selection
Range("A:A") Column A
Range("1:1") Row 1
Range("A:C") Columns A through C
Range("1:5") Rows 1 through 5
Range("1:1,3:3,8:8") Rows 1, 3, and 8
Range("A:A,C:C,F:F") Columns A, C, and F
How to Reference Cells and Ranges
A common task when using Visual Basic is to specify a cell or range of cells and then do something with it, such as enter a formula or change the format. You can usually do this in one statement that identifies the range and also changes a property or applies a method.
A Range object in Visual Basic can be either a single cell or a range of cells. The following topics show the most common ways to identify and work with Range objects.
Which way do you want to reference cells?
Referring to cells and ranges using A1 notation
Referring to cells using index numbers
Referring to rows and columns
Referring to cells using shortcut notation
Referring to named ranges
Referring to cells relative to other cells
Referring to cells using a Range object
Referring to all the cells on the worksheet
Referring to multiple ranges