So if you are writing code to refer to the RANGE object it would be like this: Application.Workbook(“Workbook-Name”).Worksheets(“Sheet-Name”).Rangeīy referring to a cell or range of cells, you can do the following things: The RANGE OBJECT is a part of Excel’s Object Hierarchy: Application ➜ Workbooks ➜ Worksheets ➜ Range and besides inside the worksheet. By using it, you can refer to cells in your codes in the following ways: For this, you need to have a solid understanding of Range Object. To make the best of VBA, you need to learn how to use cells and ranges in your codes.
A cell and a range of cells are where you store your data, and then everything starts.
When you look around in an Excel workbook, you will find that everything works around cells.
OFFSET Property Introduction to Range and Cells in VBA
