MergeCells Property Example

The following example shows the basic MergeCells property.

No Merging
MergeCells =0
MergeRow(0) =True
MergeRow(1) =True
MergeRow(2) =True
MergeRow(3) =False

This is the regular view.
Free Merging
MergeCells =1
MergeRow(0) =True
MergeRow(1) =True
MergeRow(2) =True
MergeRow(3) =False

Notice how the third employee cell (Donna) merges across products to its left and across sales to its right.
Restricted Merging
MergeCells =2
MergeRow(0) =True
MergeRow(1) =True
MergeRow(2) =True
MergeRow(3) =False

Notice how the third employee cell (Donna) no longer merges across sales.