![using vba in excel 2016 using vba in excel 2016](https://www.excel-pratique.com/view/fr/astuces_vba/img/activer_les_macros/parametres-activation-macros-excel-2016.png)
In the same way you can mention the workbook name, if you are reading the data from different workbooks. 'Here the left side part is sheets to refer and the right side part is the range to read. The below example is reading the data from Range A5 of Sheet2: If you want to read the data from another sheet, you have to mention the sheet name while reading the data. When you are reading using Cell or Range object, it will read the data from Active Sheet. Get Data from Worksheet Cell – Specifying the Parent Objects If you select any cell in the worksheet, you can see the name of that cell in the Name Box. Here is sample picture, which helps you to understand this concepts. 'Here you have to specify the Cell Name which you want to read - A is the Column and 1 is the Row
#Using vba in excel 2016 how to
The following example will show you how to read or get the data from Worksheet Cell or Range using Range Object. Get Data from Worksheet Cell – An Example of using Range Object Any Row or Column number start with 1 and You have to specify Cell(RowNumber,ColumnNumber) to read the data from a Cell of the Worksheet. In this example I am reading the data from first row and fourth column of the worksheet. 'Cells(1, 1) means first row first column 'Here the first value is Row Value and the second one is column value In this example I am reading the data from first Cell of the worksheet. The following example will show you how to read or get the data from Worksheet Cell using Cell Object. Get Data from Worksheet Cell – An Example of using Cell Object We can use Cell or Range Object to refer a Worksheet Cell. It is very simple to read the data from Excel to VBA.
![using vba in excel 2016 using vba in excel 2016](https://i.stack.imgur.com/2KEE6.jpg)
![using vba in excel 2016 using vba in excel 2016](https://i.stack.imgur.com/iK8Or.jpg)
Read or Get Data from Worksheet Cell to VBA in Excel – Solution(s): Its one of my first questions when I started learning EXcel VBA, How to Read or Get Data from Worksheet Cell to VBA? To automate any thing in excel, first we need to read the data in Worksheet and based on that we can execute the next steps.