HasMergeCells Property Example

If cell A7 is in a merged cell, this example sets the value for the merged cell to 15.

Set ma = Spreadsheet1.Range("a7").MergeArea
If Spreadsheet1.Range("a7").HasMergeCells Then ma.Value = 15