vba字典合并单元格为空,从vba中的单元格地址获取excel的合并单元格的值

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

解决方案

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.