ActiveX

To merge cells

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. To allow cells in a column to merge across rows,
   1. Set the Col property to specify the column that will allow cells to merge.
   2. Set the ColMerge property to specify how the merges can occur.
3. To allow cells in a row to merge across columns,
   1. Set the Row property to specify the row that will allow cells to merge.
   2. Set the RowMerge property to specify how the merges can occur.