another way to use the quick analysis tool in excel

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 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. 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.

Another way to use the quick analysis tool in excel