ActiveX

To span 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. If you want to verify whether a cell is already in a span, use the GetCellSpan method to return whether a cell is in a span, and if it is in a span, the anchor cell for the span.
   The control will not allow a cell in a span to be included in another span. However, you might want to check a cell, and display a message for users if they try to add a cell in a span to another span.
3. Use the AddCellSpan method to create the span, setting the parameters as follows,
   1. Set the lCol and lRow parameters to specify the anchor cell.
   2. Set the lNumCols and lNumRows parameters to specify the number of columns and rows of cells to include in the span.