[excel] Get value of a merged cell of an excel from its cell address in vba

How to get the value of a merged cell of an excel having range address like "$B$4:$B$11" in vba

This question is related to excel vba merge cell

The answer is

Even if it is really discouraged to use merge cells in Excel (use Center Across Selection for instance if needed), the cell that "contains" the value is the one on the top left (at least, that's a way to express it).

Hence, you can get the value of merged cells in range B4:B11 in several ways:

Range("B4").Value
Range("B4:B11").Cells(1).Value
Range("B4:B11").Cells(1,1).Value

You can also note that all the other cells have no value in them. While debugging, you can see that the value is empty.

Also note that Range("B4:B11").Value won't work (raises an execution error number 13 if you try to Debug.Print it) because it returns an array.

Source: Stackoverflow.com

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to merge

• Pandas Merging 101 • Python: pandas merge multiple dataframes • Git merge with force overwrite • Merge two dataframes by index • Visual Studio Code how to resolve merge conflicts with git? • merge one local branch into another local branch • Merging dataframes on index with pandas • Git merge is not possible because I have unmerged files • Git merge develop into feature branch outputs "Already up-to-date" while it's not • How merge two objects array in angularjs?

Examples related to cell

• Excel doesn't update value unless I hit Enter • Excel Define a range based on a cell value • Link a photo with the cell in excel • VBA setting the formula for a cell • Changing datagridview cell color dynamically • How to delete Certain Characters in a excel 2010 cell • How do I change a single value in a data.frame? • Set value for particular cell in pandas DataFrame using index • Copying the cell value preserving the formatting from one cell to another in excel using VBA • How to get html table td cell value by JavaScript?