VBA Merged Cell

Question

Good afternoon,

Does anyone have any idea how to return the value of a merged cell in VBA programming ?

For example: I would like range N6 to return MAI/19

Answer 1

Because the cell is merged with the VBA it uses as parameter the first cell that was merged, so the MAI/2019 value is in cell E6.

Answer 2

To obtain the value directly, the value of the leftmost and uppermost cell is usually used. But there is a better way to get, as can be seen in the following code:

Sub valor_mesclado()
    MsgBox Range("H6").MergeArea.Cells(1, 1).Value
    MsgBox Range("E6").MergeArea.Cells(1, 1).Value
End Sub