Excel Get Cell Value By Address
How do I Find the minimum value from a given range and return its cell address with formula in Excel 2010/2013/2016. The subject is automatically filled as the name of your Excel file and the same Excel file has been attached in the attachment section. & is used to join together text data (in this case the letter D) with a cell reference (E1 and E2) that contains a number value. cell A1 has a value of 10 In cell D1 I have concatenated A and 1 and got A1 How do I convert the cell address of A1 in D1 to get the value in A1 which. Every time the selection changes in the worksheet, the event is triggered. My first stab at automating this was extremely slow. You don't need any special introduction about what is a VBA cell. If match_type is 0, MATCH finds the first value that is exactly equal to value_to_lookup. To get a cell's value in VBA, we need to refer to it with the Range object and then call the. All the Excel files have the same structure i. Find the address of the max value in range in Microsoft Excel In this article, you will learn very tricky and useful Excel function to find out the address of the maximum value in a range. Follow this. Excel question - how to get the cell contents using it's address? I have a cell in my spreadsheet that finds the address of a cell to be used in a future formula. Match_type specifies the matching criteria to be used. If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns. To display the cell address including workbook and worksheet name. However, it is quite unlikely that you will display a date in this "serial" format. Get the latest Excel tips and tricks by joining the newsletter! Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. It is possible to use VBA to link a chart's axis to the worksheet, as I wrote about in Link Excel Chart Axis Scale to Values in Cells. 999999E306. From stock parts to holiday villas, from employees to logos, there are plenty of reasons to insert and automatically change an image based on a cell value. This function takes a cell reference so we still need to provide the actual cell reference. When you initially configure the Solver, it targets specific cells. The code then creates another Range representing the first cell containing values and uses the two cells to get yet another new Range representing all of the value cells. Send a mail when a cell reaches a certain value. Written by co-founder Kasper Langmann, Microsoft Office Specialist. Put this in your worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Excel. =Large(range of cells; N value) From a range of cells, you can fid the N highest value. As a simple example, the following loop will set the values of cells A1 to G3 to 0. My problem is i want to know Address Of each Excel Cells in a selected Range. For example, suppose that you want to retrieve the value shown in cell C8 in the worksheet. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your mouse to drag to a region on your worksheet. You can also specify text qualifier and the way to treat consecutive delimiters. Excel General; If this is your first visit, be sure to check out the FAQ by clicking the link above. Excel Experts, Formula for file path Fortunately, the function call does have a couple of uses - You can use it to retrieve the file path by using a few text functions. Do not click enter. The cell reference will be provided as A text string. Accessing Cells and Ranges with Winnovative Excel Library for. In the example shown, the formula in G6 is: Excel formula: Get cell content at given row and column | Exceljet. Cells(1, 1) MsgBox MyRange. Press F5 and click Special in the Go To dialog that appears. Excel General; If this is your first visit, be sure to check out the FAQ by clicking the link above. If the value of the active cell is too big. "format" Number. I am excited to let you know that the work for External Links for Excel on the web has started. Openpyxl write to Cell in Python with Examples: Writing to individual cell of Excel sheet in Python with Openpyxl module has become very easy with code continuously evolving and becoming simpler. If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns. Excel drop down list can assist you in picking up a value from a valid list to enter in a cell. Is it possible to write Excel formulas and reference the active cell as part of the formula. However, due to the extremely large amount of cells this code needed to loop through (and the data was also in an Excel table). If you need the cell value, use the INDIRECT function around the ADDRESS function, or use one of the other formulas shown in Example 2, below. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:. (To create a new worksheet for the query, select the New worksheet option. 1) Press F5 - Goto - Special - Constants. VBA Excel – Cells, Ranges and Offset : Cells. I think that's [mis|ab]using VBA: Excel itself is very good at dealing with assigning cell values based on other cells' values. If IsNumeric(rCell. If the search item is found then Find returns the cell with the value. Value <> objWorksheet2. Press F5 and click Special in the Go To dialog that appears. Now in cell A2, A3 and A4 of workbook B2. 000 customers. Read or Get Data from Worksheet Cell to VBA in Excel - Solution(s): It is very simple to read the data from Excel to VBA. And because this is a dynamic range name, you could change the Rows value to 2 in cell B1, and the Width value to 2. First, we will look at CELL and then we will move onto ADDRESS. XlsIO allows to trace the relationship between cells and formulas in Excel workbooks and returns the list of cells or range that are precedent and dependent. In some cases it is useful to know the address of the first empty cell in a column. For example, suppose that you want to retrieve the value shown in cell C8 in the worksheet. "color"-Returns 1 if the cell is formatted to have colored negative values, or 0 otherwise. You will need to place this in a Sub, either in the weeksheet, or a new Module. Labels and values. The tutorial shows how to use the CELL function in Excel to retrieve various information about a cell such as cell address, contents, formatting, location, and more. After you have selected a value from the customer list cell, you want other cells to display the related customer information. By using the Exact function in cell C1, you can ask Excel to indicate whether the number in cell A1 exactly matches the one in B1. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Select a cell and type AA into it, here I type AA into cell A26. Example: =sum(A1:H15) Where I want to sum cells from A1 to let's say A10 but cell address A10 is actually located in H15. List User info in Excel spreadsheet. 09 / Tags: MATCH Excel has a function to locate a value on a range of cells and return the number of the row where the value is found, it's the MATCH() function. It should be noted that, in the spreadsheet, cell A1 is formatted with the Custom Format #,##0; [Red] - #,##0. The Address property returns, as a string, the address of the cell like “A1”. And then you can release the button of “Shift”. Thank you very much. Get the latest Excel tips and tricks by joining the newsletter! Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. (This is easier if you know where the cells are ahead of time so you don't need to mess around trying to find the last cell. Lookup_array is a contiguous range of cells containing possible lookup values. It contains code examples for almost anything y ou want to do with VBA Find. This Value is then assigned to the score variable. Now in cell A2, A3 and A4 of workbook B2. Lock Excel Cells. This example teaches you how to find the cell address of the maximum value in a column. The bad news first: There is no built-in way in Excel to read out a hyperlink, for example with a formula. In this video we get Excel to show which of 3 pictures has the most votes. Read or Get Data from Worksheet Cell to VBA in Excel - Solution(s): It is very simple to read the data from Excel to VBA. A cell address is returned as a text string, not an actual reference. This will get us to cell E20. Lookup a value and return cell address with formula 1. Click on this link to get to know more about "Name Range in Excel". Fast Cash For Bad Credit. In the example shown, the formula in G6 is: =INDIRECT(ADDRESS(G4,G5)) The Excel ADDRESS function returns the address for a cell based on a given row and column number. In the example shown, the formula in G6 is: Excel formula: Get cell content at given row and column | Exceljet. Method 1: Getting the hyperlink addresses manually. Find the Cell Address of a Value Using the ADDRESS Function. Important read this : The code on this page is only working when you use Outlook as your mail program. I discuss these spreadsheet “profiles” because, today, I want to show some strategies for finding the last used cell in an Excel worksheet or range. I want somehow to display the contents of that cell or to be able to make a formula use that address. We will use the VLOOKUP method because the Customer Name is the first column in the Customers worksheet. It's rare that you need to know more than that. There are many ways to create lookup formulas. Does anyone know if it's possible to have a cell address in a formula that references another cell. Hello, i'm creating an application that passes the information contained in a Gridview to an Excel document. The cells on a worksheet have a default gray border, but a user can change the border color. Each cell in Excel has a unique address, like A1 or C345 or D48 or whatever. The $ sign in a cell reference affects only one thing: It tells Excel how to treat your references when you copy the cell. Now re-run the paired t-test. In other words, how to take the value of a cell located in one worksheet and add it to the value of another cell located in another worksheet to come up. The Microsoft Excel ADDRESS function returns a text representation of a cell address. Additional examples show how this function is often used in conjunction with other Excel functions to test the outcome of calculations. I'd like to have the cell address returned along with a value when I use the MAX function. For example, i give cell B2 name "Hello" and value "2". Click here to see how the formula works visually & interactively Sometimes we have a list that we enter our daily sales into and want to show the last transactional value entered. Just a simple question while using Excel, that I want to fix one cell value on another formula cell while copying the formula to another rows. Most your time working with Excel is spend in the worksheet area - dealing with cells and ranges. Syntax: CELL(info_type; cell_ref) returns information about the cell cell_ref. Find value in Range, Sheet or Sheets with VBA. i need a formula to highlight the cells, i will enter the total value excel should highlight the cells which sum equals to that value An Excelchat Expert solved this problem in 11 mins! how do i get a cell to express a number of a cell that has a value entered. You can double-click the filled cells to check their formulas for accuracy. " "must surround text data inside of the cell references (in this example, the letter D). Your data could be in adjacent cells (rows/columns), or it could be far off in the same. That is, it returns a Range type of one cell. Learn Formulas, Excel and VBA with examples. Below are the steps you need to follow to combine values from this range of cells into one cell. Regardless of the complexity of task, ‘Serial Number’ is a column which is included in almost all types of worksheets. I'm trying to get the cell address, not the contents, of a cell referenced using VLOOKUP. "filename" Filename of the file that contains reference. The cell reference will be provided as A text string. The data updates each and every month. The Worksheet range used by Excel is not often the same as the Excel last row and column with values. I need to write hard-coded value "my value" in cell "C24" to an already existing MS excel sheet. Find property but I only seem to be getting the value that I'm searching for instead of the cell address. In the example shown, the formula in cell G8 is: Excel formula: Get address of lookup result | Exceljet. Select the data range where there are blanks to remove. This post provides a complete guide to using the Excel VBA Find function. The Find Return Value. o Workbooks Administration: Individuals usually didn't live so long as now therefore theirappears didn't suffer the particular ravages of aging. In order to get the address of the cell from the Range, we use the get_Address method of the Range object. Openpyxl write to Cell in Python with Examples: Writing to individual cell of Excel sheet in Python with Openpyxl module has become very easy with code continuously evolving and becoming simpler. Select a column in your excel data and Maptive will automatically find all of the unique values in that column. An absolute cell address is a cell address that does not change when you move a formula from one cell to another. This time the t-statistic is 6. Here, a User Defined Function also can help you finish this task, please do as this: 1. The supported forms for ADDRESS are as follows:. The values will be from tab a tab called "LP Allocation" I tried the the 'Indirect' formula but it was no help. I've tried '=CELL("address", VLOOKUP(5,Table,2,false)', but I'm getting a. Insert the formula =IF(A2="Show Hyperlink 1″,E2,E3), which basically tells excel to show hyperlink 1 if the value in cell A2 is "Show Hyperlink 1" or show hyperlink 2 otherwise. Value) Then MsgBox "Cell " & rCell. Address function creates a text based on the address of cell in the spreadsheet. A better way to indicate the active cell would be to use an event macro. The motto is to get the latest value for each fund and add the values of this. The array formula in column G filters values in column C using a condition in cell E3, comparing it with […] Lookup multiple values in different columns and return multiple values Jason C asks: I have a set of data, like the one you used in the original example that also […]. Copy the code in a Standard module of your workbook, if you just started with VBA see this page. If you see #NUM! or #DIV/0!, look for unanticipated values of the decision variables which lead to arguments outside the domains of your functions – such as a negative value supplied to SQRT. So it's not possible to, say, select a range based on returning the. With Excel, you will boost your business data processing with one of the world's most popular productivity tools. Lookup a value and return cell address with formula 1. Excel VBA Check if Cell is Empty: Step-by-Step Guide and 4 Examples to Check if Cell Range is Empty with Macros returns a value smaller than the value returned by. Hi, I'm working on a project in Visual Studio 2010 - C# that has to read MS Excel spreadsheets and get values from certain cells. if there is an Operator Names in cell C9 of one Excel file, then in other Excel files as well, there will be the operator name in cell C9 itself. Detect when the user has entered a value into the cell; Update the Region PivotField object with the value of the cell; For the sake of clarity, let's assign a name to the cell where the user will enter the new selection for the field (i. In some cases it is useful to know the address of the first empty cell in a column. 1) How do I get the value of the cell that is 2 cells to the left?2) How do I get the address of the cell that is 5 cells above?^6:: Cell_address = % ComObjActive(Excel. so I need to find out the last row of A column and using offset to fill the Range B1:B10 ( this is an example) i have to given the dynamic range. To do this, we need a way to write a formula that tells Excel to retrieve the value in a cell, given the address of the cell. How To Use The Excel Functions CELL And ADDRESS. how to get the value of a cell by its name. Hello, i'm creating an application that passes the information contained in a Gridview to an Excel document. I've tried '=CELL("address", VLOOKUP(5,Table,2,false)', but I'm getting a. I'm trying to write code that would get the row numbers of non-continuous rows. And because this is a dynamic range name, you could change the Rows value to 2 in cell B1, and the Width value to 2. In order to get the last cell in a range, you first need to think about what constitutes the "last cell". Value * Target. Important Points to Remember. When you initially configure the Solver, it targets specific cells. For this, i'm using Microsoft. UsedRange If cell. An individual eat less food you simply need to get a new approach to eating and re allocation an prioritising of the foods but I am afraid those twenty donuts per week will have to proceed!What exactly get Easy Personal Loans Us Dollar 800 to perform issue actually is the best diet to lose. Ex 1: Cell address from row and column With the ADDRESS function, you can get a cell address, as text, based on a row number and column number. How do I use conditional formatting to highlight a cell in one column based on the value of another cell in another column? Case in point, I'm running some tests right now. since changing the active cell doesn't cause a recalculation. When using python if you want to write to individual cell or cells with openpyxl module, there are technically three methods. Problem with getting value before Worksheet_Change event. Cells in the spreadsheet are referred to by rows and columns. If the cell refers to a range, it is the first cell in the range. A great many posts and blogs poorly demonstrate how to use the Excel object model. When this cell reference in excel is duplicated to a different location, the relative Cell references in excel correspondingly also changes automatically. We can use Cell or Range Object to refer a Worksheet Cell. =Large(range of cells; N value) From a range of cells, you can fid the N highest value. The value 1001 should show in D2; In Step 4, our Excel formula will look at the original street value in cell C2 (1001 Drake Ave. Get started with Excel, the industry-standard in spreadsheet tools. I am in the midst of running my own exercises on various workbook uses and am currently building some basic invoices. Yet Excel is capable of far more than the standard editing of cell contents allows, through the magic of Visual Basic for Applications scripts, or VBA. Press F5 and click Special in the Go To dialog that appears. The cell reference will be provided as A text string. Using the MATCH function in Excel - find a match in a list without duplicates. The following figure shows all the objects mentioned. To the question: Out of 100 cells in the range only the top 50 have a value in them. The best way to do it is to use a Range or Cells reference if you can. Another way without formulas is to select the non-blank cells in a row using the following steps. A numeric value that specifies the column number to use in the cell reference. If the search item is found then Find returns the cell with the value. The data updates each and every month. Ex 1: Cell address from row and column With the ADDRESS function, you can get a cell address, as text, based on a row number and column number. Trying to clarify. Remove Quotes In Excel Generally it is observed that we get some embedded quotes or quotation marks in our data specially if it is imported from some different source. Excel Find Column Containing a Value June 12, 2013 by Mynda Treacy 20 Comments Last week I had an email from Mike asking how he can lookup a suburb in a range of columns and return the post code from the header row. This function takes a cell reference so we still need to provide the actual cell reference. Rows are horizontal and labeled with numbers. An absolute cell address is a cell address that does not change when you move a formula from one cell to another. Conditional formatting, a feature available since Excel 97, applies formats to selected cells that meet criteria based on values or formulas you specify. An INDEX function can be used to MATCH the lookup value in a range of cells. Do not click enter. Excel allows you to refer to any cell on any worksheet, which can be especially helpful if you want to reference a specific value from one worksheet to another. A relative address will change in the relation to the number of cells you move. This Value is then assigned to the score variable. " End If 'This control checks if a cell contains an error, for instance 'division by zero or a formula with a reference to a non-existing 'named cell. The cell value of cell C2 in Sheet S3 is 31. For example, if cell A1 contains the hyperlinked text whose URL who you want to extract, you can just type “=GetURL(A1)” on any other cell on the sheet to extract the hyperlink. The ADDRESS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. This function returns the address of a cell or range in either A1 or R1C1 style. You will need to place this in a Sub, either in the weeksheet, or a new Module. NET This sample shows how to access the ranges and cells from a worksheet. The indirect() function ";returns the reference specified by a text string". The ActiveCell is whichever cell is currently selected. Cells(-1,0) – refers to cell B1 (two rows above the top left cell, one column to the left) As you can probably see, this kind of referencing can get a little confusing! It’s usually easier to use the Offset property for this kind of thing. The Excel function that allows us to fetch a value for a relative cell is INDIRECT. Use the Address and Match. ColorIndex = 0 End If Next set objExcel=nothing. Accessing Cells and Ranges with Winnovative Excel Library for. 5 hours of content 24/7; Get downloadable Excel workbooks which you can use to follow along. Written by co-founder Kasper Langmann, Microsoft Office Specialist. "filename" Filename of the file that contains reference. Highlight Excel Cells Based on the Value of Another Cell In many cases, you will base the formatting rule for your Excel cells on how they compare to the value of another cell. Your data could be in adjacent cells (rows/columns), or it could be far off in the same. Send a mail when a cell reaches a certain value. If you are processing multiple rows you can use the cells method to make it a lot easier to refer to specific elements without having to use the A, B C column identifiers. The OFFSET function in Excel is one of the Lookup functions and is great if you want to reference a range of cells and use that reference to do a calculation. The cells on a worksheet have a default gray border, but a user can change the border color. Where do I paste the code that I find on the internet. Click “Next” In step 3 of “convert to Text Columns wizard”,. Name ranging in excel sheet means giving a name to a Range to refer it by the name given. Changing The Cell References While Looping. I planned to use the call statement for both macros, but I can’t figure out how to set up the loop to change the cell value (the cell value needs to change for the value change macro and because I’ve set up several vlookups with that cell). The relative cell references should be different for each cell, depending on its row. In a column A if the value is zero, and in column K the value is. And then click the tab of “2016”. The first would be Since a column can be from A to ZZ (A-Z and then AA to ZZ), you could divide the column number (2=B, 5=E, etc. Here are several ways you can get the address you need. Excel question - how to get the cell contents using it's address? I have a cell in my spreadsheet that finds the address of a cell to be used in a future formula. -- Find cell value from row and column number -- Return address of cell with highest value Watch this video to see how to use the Excel ADDRESS function, and combine it with other Excel functions. This Value is then assigned to the score variable. In my windows application ,i want to get specific cell address in a worksheet,then by using the address i need to write data from their. Find value in Range, Sheet or Sheets with VBA. It does not return a cell it returns a range object. For the Destination parameter we reference the destination workbook, worksheet, and the beginning cell of the range to paste to. Using this method, we get the bottom right cell with data. To the question: Out of 100 cells in the range only the top 50 have a value in them. Now if somehow we can build reference to worksheet based on the value in cell E1 we will be able to fetch the value from that worksheet easily. Copy method does a regular copy and paste that includes formatting and formulas. If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns. If IsNumeric(rCell. Openpyxl write to Cell in Python with Examples: Writing to individual cell of Excel sheet in Python with Openpyxl module has become very easy with code continuously evolving and becoming simpler. Change Font Color and Highlight One Cell Based on Status or Column Value using JQuery in SharePoint. 999999E306. In order to better analyze those values, you will need to extract the numbers and texts. By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. This goes on the right of an equal sign: score = ActiveCell. Openpyxl write to Cell in Python with Examples: Writing to individual cell of Excel sheet in Python with Openpyxl module has become very easy with code continuously evolving and becoming simpler. In this lesson you can learn how to use ADDRESS function. Write the following formula and press CTRL+SHIFT+ENTER. The cell address is the address of the cell that was copied. I'm trying to get the cell address, not the contents, of a cell referenced using VLOOKUP. The Excel ADDRESS function is combined with Watch the Video. I want the endDate value in the url to be taken from cell A2. To get a value from a cell, you can use ActiveCell. =Large(range of cells; N value) From a range of cells, you can fid the N highest value. Additional examples show how this function is often used in conjunction with other Excel functions to test the outcome of calculations. Thus, INDIRECT(B2) does not return the value in cell B2, but rather the value in the cell whose address is in cell B2. This Excel VBA tutorial explains how to get value before Worksheet_Change event. The cell value of cell C2 in Sheet S3 is 31. Ex 1: Cell address from row and column With the ADDRESS function, you can get a cell address, as text, based on a row number and column number. If I understand your question correctly, you would want to use the indirect() function, coupled with the concatenation operator (&). Excel Experts, Formula for file path Fortunately, the function call does have a couple of uses - You can use it to retrieve the file path by using a few text functions. If the search item is not found then Find returns an object set to Nothing. Microsoft Excel; I am working in Office 2003. Cells property (Excel) 05/30/2019; 2 minutes to read +3; In this article. let's make the cell a named range). Click Insert > Module, and paste the following code in the Module window. The Excel ADDRESS function is combined with Watch the Video. So for example after applying the autofilter only rows 1, 5 and 7 show up. To begin, click on the Formulas tab on the Ribbon and then on the Text button. If you search row-by-row, moving across one row then down to the next, the last cell is the right-most cell in the last row than contains any values. Now, just select the entire inside portion of concatenate function and press F9. column returns a number, where as range. Use Range object along Activate method. When using python if you want to write to individual cell or cells with openpyxl module, there are technically three methods. Get the most value from your Sage solution; Sage University training courses help you and your organization in many ways. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your mouse to drag to a region on your worksheet. Additional examples show how this function is often used in conjunction with other Excel functions to test the outcome of calculations. By finding the sheet name using an Excel formula, it ensures that if the sheet name is changed, the formula returns the new sheet name. "color" Returns 1 if the color is a negative value; Otherwise it returns 0. Active 7 years, 9 months ago. So for example after applying the autofilter only rows 1, 5 and 7 show up. The formula simply states that the cell’s value is to be equal to the value displayed in the cell address shown. Cells(-1,0) – refers to cell B1 (two rows above the top left cell, one column to the left) As you can probably see, this kind of referencing can get a little confusing! It’s usually easier to use the Offset property for this kind of thing. Entering a value in the next empty cell: 9. A numeric value that specifies the row number to use in the cell reference. Yes, you can link the contents of an Excel text box to data in a cell as follows: 1. By passing 2 for the range() function’s “step” parameter, you can get cells from every second row (in this case, all the odd-numbered rows. Use Nitro's industry-leading PDF to Excel converter to create better quality DOC files than the alternatives. How To Reference A Cell in Excel: Absolute, Relative, and Mixed References Explained. If the range consists of more than one cell, VBA returns True only if all cells in the range contain a formula, or False if all cells in the range don't have a formula. My first stab at automating this was extremely slow. Use Range object along Activate method. Ask Question Asked 7 years, 9 months ago. In a column A if the value is zero, and in column K the value is. A numeric value that specifies the type of reference to return. Excel VBA Value and Value2: Step-by-Step Guide and 8 Examples to Set or Get a Cell's or Cell Range's Value with Macros By J. The ADDRESS function allows us to do just that, but it requires a row and column. How would I return the bottom most cell of a range that has a value in it. The values will be from tab a tab called "LP Allocation" I tried the the 'Indirect' formula but it was no help. See screenshot: 2. In a column A if the value is zero, and in column K the value is. In cell A1 the value is 2015-10-07. Retrieving Values Using References Based on Row and Column Numbers in Microsoft Excel 2010. For example, i give cell B2 name "Hello" and value "2". The information returned depends on the (case insensitive) text string info_type, which can be set as follows:. The INDIRECT function is designed to do just that. Find is a very powerful option in Excel and is very useful. Additional examples show how this function is often used in conjunction with other Excel functions to test the outcome of calculations. This Value is then assigned to the score variable. rangeLastArea. To get the correct results copy X and Y to two new columns and remove the data in the cells that have no value for the other measure. In my windows application ,i want to get specific cell address in a worksheet,then by using the address i need to write data from their. Range) Range("A1"). Excel likes working with large blocks at a time, it's more or less optimized for that. Range("C3:D4"). After running the VBA macro code, you will get a message box that tells you how many duplicate cells were found and ask if you want to highlight them yellow. This query uses 3 parameters: Symbol, StartDate, EndDate. I'm having difficulty getting the row number as i need to obtain the values in certain cells in that row.