Value Property Example

This example creates a merged cell from the specified range and then places a value in the merged cell.

Spreadsheet1.Range("a1:c3").Merge
Spreadsheet1.Range("a1").Value = "Monday"