Excel VBA Reading and Writing Data to Cells

Thanks! Share it with your friends!


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.


Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.