This video shows the different ways that you can reference cells within your VBA code. This is a fundamental skill you will need when writing VBA routines as it enables you to read and write values from the cells in the spreadsheet.
We have listed the items covered and where they are covered in this video below to help you make the most of this video in the least amount time:-
Adding data to cells (1.00)
Selecting a different cell using the offset function (2.45)
Adding data to cells using the offset function (5.00)
Reading data from a cell using a range statement (6.00)
Reading data from a cell using the cells.() statement (9.30)
If you have found this video useful please Like or Share it using the buttons above or leave us a comment below.