Access Excel worksheet cells using a1 notation
We have learnt how to create a new workbook using VBA. Next we learnt how to open the newly created workbook automatically using the 'Open' method. Today we learn how to access Excel worksheet cells so that we can enter data into an Excel worksheet using VBA and also perform manipulations like formatting on the entered data.
Now a common task when using a
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.
A Range object in Visual Basic can be either a single Excel cell (Eg. A1) or a range of Excel cells (Eg. A1:D5).
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.
Range("A1").Value = "First Name"
Range("B1").Value = "Last Name"
Range("C1").Value = "Designation"
Range("D1").Value = "Salary"
Range("E1").Value = "Perks"
Range("F1").Value = "Total Package"
Workbooks("Book1").Sheets("Sheet1").Range("A1:F1").Font.Bold = True
Implementing the macro:
the Excel training video below to
see the macro in action: