I am trying to get at the value of the merged cells E1:G1.

This code works fine:
value_merge2 = Sheets("Sheet2").Range("E1").Value
MsgBox value_merge1

This code just gives a blank:
value_merge1 = Sheets("Sheet2").Range("A1").Offset(0, 4).Value
MsgBox value_merge2

Is there a way to use something like the second set of code to still
give the value of the merged cells?