Access Excel worksheet cells using a1 notation

A common task when using a macro in Microsoft Excel is to access Excel worksheet cells using a1 notation 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.