Referring to Excel cells and ranges using the A1 notation in a macro

How to Reference Cells and Ranges in Microsoft Excel
A common task when using Visual Basic or a macro is to specify a cell or range of cells in Excel 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 Excel cell or a range of Excel cells.
The following example shows how to reference cells and ranges using A1 notation in Microsoft Excel.
You can refer to a cell or range of cells in the A1 reference style by using the Range property in Excel. The following subroutine changes the format of Excel cells A1:D5 to bold.
Sub FormatRange()
Workbooks("Book1").Sheets
("Sheet1").Range("A1:D5").Font.Bold = True
End Sub

The following Excel training video shows how to access the Excel range and make it bold.

Custom Search

Further links
How to: Refer to Cells and Ranges by Using A1 Notation
Microsoft Excel Training Videos